Security in Access

[JHausmann]

You need to create a new .mda (or .mdw) file. In that file, create a user that has admin capabilities, reduce the existing "admin" user's capabilities to minimal (or none at all), then assign a passwd to the user "Admin". Make sure you join the file, using wrkgpadm.exe. Create a new database, logged on as the new user. copy the files in from your old database.

If you've done everything right, your users won't be able to open up your database without the new mdw (mda) file. You'll need to supply and reference it in order to use it in VB.

[This message has been edited by JHausmann (edited 08-13-1999).]

[Brettrb]

Hi.

Recently, I have been trying to secure my database so that we can send a read only version with some features removed to some of our company's clients. However when I try setting it up with user/admin groups the database is only protected on the computer I set the groups up on. So when I transfer the database to another computer there are no passwords or read-only restrictions set.

Has anyone run into this problem in Access?

Thanks for all the help I have been receiving lately (I have probably been posting more than most people lately).

Brett Becektt
brettrb16@yahoo.com