.ldb Default Directory Change?

[Brenda]

I have an Access database I want to control read/write
permissions through by the folder it's in instead of using
the Access security controls (want to make it able to be
updated and maintained after I'm gone).

The problem is when someone with write permissions opens
the database, someone with read permissions cannot open
it. The person with write permissions creates the .ldb
file in the folder, and only other people with write
permissons can access it when that file is created. The
read only users get the "could not lock file" error
because they are not able to write/change/delete in that
particular directory, which is intended. Multiple read
only users can access it without difficulty and the .ldb
file is not created.

Is there any way to change the directory the .ldb is
created in from the default (the same directory the
database is in) to another one that I could give
permissions to everyone in? Would this solve my problem?

Is there another solution to this problem to enable people
with write access and those with read only access to the
folder to view the database concurrently?

Thank you in advance for any assistance.

 

[Lynn Trapp]

You need to give EVERYONE change permissions to the folder the database is
in, then grant read only permissions to the file for those people who don't
need write permissions.

 

[Joan Wild]

You can't change the folder for the ldb. The only thing I'd suggest is that
you give all users full permissions on the folder.

You can hide it using \\servername\share$ rather than \\servername\share.
That will hide it in Windows Explorer, but if someone knows the path, they
can still type it in the filename.

In addition you may be able to set permissions on the mdb file (while
keeping full permissions on the folder). Be carefull though to check the
permissions of the file after a compact, as it will inherit the permissions
of the folder since a new file is created during the compact process. There
is some information about this at
http://www.trigeminal.com/usenet/usenet028.asp?

 

[Brenda]

Thank you both! Setting the permissions on the file
itself instead of the folder will work wonderfully. I
really appreciate the assistance!