double access

[nfireman]

I have a realy serious problem that when I open msaccess (I have access 2003) and I'm trying to reach the database from my application, the application fails to get to the database. Aparently this happens because access is opened but isn't it supposed to allow multiple access to the database?

Anyone knows why?

Thanks in advance.

 

[The_Doc_Man]

If you are sharing the DB, you need to implement workgroup security (a topic that should provide LOTS of hits inside this forum's search function). One of the permissions associated with the workgroup security login is the ability to do an OpenExclusive. Which with workgroup security, you can disallow to everyone except yourself.

 

[Pat Hartman]

You don't need to implement security to share databases. ALL Access databases are ALWAYS secured. It is done silently so most people never realize it.

Unless someone is specifically opening the db in exclusive mode, the two most common causes of this problem are:
1. Insufficient network permissions. Users must have the ability to add/change/and delete files from the Access db's directory on the network drive. Without this ability, Jet cannot properly manage the .ldb file which is how it tracks changes and will open the db in exclusive mode.
2. Objects in shared databases may not be changed. If you change objects such as forms or reports, Jet will not allow access to the database by other people. If you have a development team and you need to provide the ability for multiple team members to make object changes to a shared database, you must use a product such as SourceSafe to manage the change process.