Access and Network Permissions

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

It appears that placing a database in a network folder who's security is set
to Read Only forces the database into Exclusive mode, even though it's
specifically set to Shared.



Is there any was around this?
 
Hi
Correct. You would need Read/Write privilige to the network share. Access
needs to create a locking file (i.e. LDB file) in the same folder as the
database. If Access can't create it, it defaults to Exclusive mode.

Immanuel Sibero
 
Hi Bill,

No, as far as I know. It would really be a nightmare if you could though.
In a typical multiple frontends and one backend setup, imagine if one
frontend creates the LDB file on the local drive, the other frontends may
not be able to access the LDB file.

HTH
Immanuel Sibero
 
Back
Top