Workgroup Information File Error
I am running this line of code in Excel VBA
Set db = OpenDatabase(stDataPath)
I have checked the value in stDataPath ("H:\Order book\SOOsieorderbook.mdb")
For one of my users the line of code crashes with the error:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I don't have a lot of experience with workgroup information files, but I know what they are. There isn't one for this database. If the user tries to open the database directly, it opens fine.
The only thing I've noticed is that the users machine is referencing Access 15 in the VBA, when she is using Office 16, and the other users in the company have the Access 16 reference.
Any thoughts about why this user could be getting this error? What do I need to check.
Set db = OpenDatabase(stDataPath)
I have checked the value in stDataPath ("H:\Order book\SOOsieorderbook.mdb")
For one of my users the line of code crashes with the error:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
I don't have a lot of experience with workgroup information files, but I know what they are. There isn't one for this database. If the user tries to open the database directly, it opens fine.
The only thing I've noticed is that the users machine is referencing Access 15 in the VBA, when she is using Office 16, and the other users in the company have the Access 16 reference.
Any thoughts about why this user could be getting this error? What do I need to check.
Last Comment
ASKER
Yes, that .mdb is shared, and the code is in a shared Excel file.
All the users should be on the same version of Office, but the user in question has just had her profile rebuilt and the fact that References are showing Access 15.0 Object library when it should be 16.0 points us to think there is a problem there.
We have just rebuilt her Office installation, but she still has the problem.
Can you clarify?
The shared Excel code has references to the Excel and Access object libraries. The code tries to open Access FE, but only as a DAO data source, so that the code in Excel can create new records in the data (SQL behind the Access FE). I assume the references that get reset are the ones in Excel. There are references to Excel 16.0 object library for all users, and Access 16.0 except for the user who is having trouble who has Access 15.0 object library. Let me know if that doesn't make sense.
All the users should be on the same version of Office, but the user in question has just had her profile rebuilt and the fact that References are showing Access 15.0 Object library when it should be 16.0 points us to think there is a problem there.
We have just rebuilt her Office installation, but she still has the problem.
Can you clarify?
The shared Excel code has references to the Excel and Access object libraries. The code tries to open Access FE, but only as a DAO data source, so that the code in Excel can create new records in the data (SQL behind the Access FE). I assume the references that get reset are the ones in Excel. There are references to Excel 16.0 object library for all users, and Access 16.0 except for the user who is having trouble who has Access 15.0 object library. Let me know if that doesn't make sense.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Access 16 isn't in the list. There must be something wrong with the user's profile so I've asked the guys responsible for that to take a look. The user has recently been upgraded to Windows 10, and the profile has been rebuilt a couple of times already.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
If they are sharing a FE, then when someone with the latter version of Office opens it will reset the reference and when the user with the earlier version of Office gets it, the will get errors related to missing references.