Avatar of Laurence Martin
Laurence MartinFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

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") and it is correct.

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.
DatabasesMicrosoft AccessVBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Laurence Martin
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

does each user have the FE on their computer, or are they sharing a FE?

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.
Avatar of Laurence Martin


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.
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Blurred text
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.
See Pricing Options
Start Free Trial
Avatar of Laurence Martin


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

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.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo