| re: Lock an access db
On Wed, 07 Sep 2005 10:01:28 GMT, Bob <goff1234@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.
[color=blue]
>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.[/color]
| 
