Vista Cannot Open Database

[shep]

Two linked databases (EPICS and CIMS) reside on XP server running ACCESS
2003. EPICS and CIMS are linked by a table. Some users have XP OS and
either ACCESS 2003 or 2007 and can open and work in either database.

Some users have Vista and ACCESS 2007. They can open EPICS but not CIMS.
When attempting to open CIMS, they get error message, "The operating system
will not allow the Microsoft Access database engine to create a lock file
(.LDB) in the same directory where the database file resides. You need to
have write privileges to the directory that contains the database you are
trying to open. This error can also occur if you are trying to use the
passive shut down/connection control feature while the database is opened
exclusively."

Both EPICS and CIMS are set to allow all users all permissions.

Any help appreciated.

 

[shep]

Thanks for your response Mr. Meyer.

I am not familiar with the process you propose nor with ACCESS 2007. May I
ask for additional guidance?
1. I should create a folder on the C drive of Vista machine and name it e.g;
"EFCST".
2. Use ACCESS 2007 to Trust that folder? How do I do that?

Thanks for your patience and your help.

 

[Arvin Meyer MVP]

The Office button on the upper left corner of Access 2007 has choices for
Options >>> Trust Center where you can follow the dialogs to create the
Trusted Location.

 

[shep]

Thank you very much

The Office button on the upper left corner of Access 2007 has choices for
Options >>> Trust Center where you can follow the dialogs to create the
Trusted Location.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com