how do i lock a shared database?

[Guest]

I've created a shared database where I am the primary editor of it. How can I
lock this database so that all others can only view it in read-only mode even
when I'm not using it at the time?

Thanks.

 

[MacDermott]

Well, you could implement Access security...

 

[Guest]

Easier yet, use Windows security. Give them read only priv. on the .mdb file.
More details here:

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

This article includes the following statement:

"If you plan to share a database, the .mdb file should be located in a
folder where users have read, write, create, and delete privileges. Even if
you want users to have different file privileges (for example, some read-only
and some read-write), all users sharing a database must have read, write, and
create permissions to the folder. You can, however, assign read-only
permissions to the .mdb file for individual users while still allowing full
permissions to the folder."


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Well, you could implement Access security...
__________________________________________


I've created a shared database where I am the primary editor of it. How can
I lock this database so that all others can only view it in read-only mode
even when I'm not using it at the time?

Thanks.