I have created a "library" Access Database. I "reference" this library file within another Microsoft Access database by using Tools->References->Browse->
File Name: (Libraryfile.ac cdb)
Files of Type: Microsoft Access Databases (*.accdb)
This works as planned.
When I create a second Microsoft Access that references the same library, it works.
Unfortunately, it does NOT work when I open both applications at the same time. It doesn’t appear to share the “library file” (Libraryfile.ac cdb).
When I open the first app, the library file creates a .laccdb file. I’m assuming this is locking out the use of the library file when the second application tries to open and use the referenced Libraryfile.acc db.
Is there a way to share the library file among two applications running at the same time?
• This is not a case of splitting front end and back end functionality.
• My file options Client Settings are set to Shared
• I have tried putting the library file on my local machine and the Network location
• I am using Access 2010
File Name: (Libraryfile.ac cdb)
Files of Type: Microsoft Access Databases (*.accdb)
This works as planned.
When I create a second Microsoft Access that references the same library, it works.
Unfortunately, it does NOT work when I open both applications at the same time. It doesn’t appear to share the “library file” (Libraryfile.ac cdb).
When I open the first app, the library file creates a .laccdb file. I’m assuming this is locking out the use of the library file when the second application tries to open and use the referenced Libraryfile.acc db.
Is there a way to share the library file among two applications running at the same time?
• This is not a case of splitting front end and back end functionality.
• My file options Client Settings are set to Shared
• I have tried putting the library file on my local machine and the Network location
• I am using Access 2010
Comment