Database is always opened in exclusive mode

[dan08]

­I have a Access 2010 database that is basically a front end for a MySQL database. There are some local queries and forms and VBA code. For some reason the database will only let one person use it at a time. I checked that the default open mode is not set to exclusive. I've never set anything to make it open exclusively. Is there something I'm missing that I can check? Is it this something to do with it being connected to a MySQL backend?

 

[PHV]

The users should have full rights on the directory where is located the access database.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lameid]

In addition to the file permission PHV mentioned, an exclusive lock is made any time an object is designed or change saved (like the SQL for a SQL Pass thru query). This is one of several reasons it is best practice to put the Front End on each user's local machine as opposed to sharing it.

 

[benderulz]

I have seen this issue if the network share is mapped using an IP address instead of the host name.

For example, "\\192.168.11.11\share" should be mapped as "\\my_server\share"

However I agree with lameid, you should put the Front End on the user's machine.

 

[lameid]

That is interesting in regards to the direct IP mapping. Any idea as to why? I can't think of a case I would use an IP address but it does peak my curiosity.