Lock an access db

[Bob]

I am look for a technique to lock an access db from being changed. The
db is to be view by lots of users but I do not want any of them to
add, delete or change any records but there are two users which will
be change the db records, if this can be done using visual basic this
would be ideal as the shell as been written in vb6.

--
Bob

[Tom van Stiphout]

On Wed, 07 Sep 2005 10:01:28 GMT, Bob <go******@NOSPAM.ntlworld.com>
wrote:

Depends on how much security you need and how much you can control the
environment. Here are some suggestions:
* Put the back-end on a share that's readonly for most.
* Give most people a shortcut with the /readonly command line switch.
* Check the Windows user name, and write code such as this in all
forms:
Me.AllowEdits = (strWindowsUserName = "ntlworld\golff1234")
* Use Access Security - note: this is an advanced topic

-Tom.

I am look for a technique to lock an access db from being changed. The
db is to be view by lots of users but I do not want any of them to
add, delete or change any records but there are two users which will
be change the db records, if this can be done using visual basic this
would be ideal as the shell as been written in vb6.