Access and Network Permissions

[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?

 

[Immanuel Sibero]

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

 

[Bill]

Thanks. That's clear.

Any way to have access create the ldb file somewhere else?

Bill

 

[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