Database Access Setting?

[Bob Bonta]

I posted this in some of the other areas of this forum for
more visibility. Please excuse me if this is in the wrong
area.

Does anyone know if there is an MSAccess database setting
I can turn on or off which prevents a user from gaining
exclusive access to the mdb?

I have a tool (non-Microsoft product) which uses an MDB
backend. When it accesses the database, a .ldb file is
created and it opens it exclusively. The exclusive open
may not necessarily be intentional but a default action.
If I can do something to ensure the database is never
opened exclusively, I may be able to have a 2nd process
access the database without receiving the error I'm
getting.

Any assistance would be GREATLY appreciated!

RSB

 

[Rick]

In the security, locate your user, select 'database' from the 'object type'
drop-down and then uncheck the 'open exclusive' checkbox.

Rick

 

[Guest]

Thank you for your hasty reply.

However, I have no front end to this access database.
Frankly, it is a database that is only used by this
specific tool. But in order for me to launch the database
externally from this tool, I need to ensure,
environmentally within Access, that it never is opened
exclusively.

Any thoughts?

v/r

Bob ...