ldb in another folder?

[cpet]

Is it possible to have Access 2003 put the ldb in a different folder that the
mdb is in? Thus allowing users Read-only access to the data without having to
set up database security.

[Chris O'C via AccessMonster.com]

Re: ldb in another folder?

Access can't put the ldb file in another folder. It has to be in the same
folder as the mdb file because the locking mechanisms use virtual addresses
that point to locations in the ldb file in the exact same path as the mdb
file. Wherever the mdb file is, the ldb file will be created.

Have the users open the mdb file with the read-only switch.

Chris
Microsoft MVP


cpet wrote:

>Is it possible to have Access 2003 put the ldb in a different folder that the
>mdb is in? Thus allowing users Read-only access to the data without having to
>set up database security.

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200804/1

[Rick Brandt]

Re: ldb in another folder?

cpet wrote:

Is it possible to have Access 2003 put the ldb in a different folder
that the mdb is in? Thus allowing users Read-only access to the data
without having to set up database security.

I don't beleive one has anything to do with the other. If you make the file
or the folder read-only for those users then no ldb file is created in the
first place.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com