Web Development·11,944 discussions

Access 2000 Security

Locked

Does anyone know how to set up security (without reading 65 pages) on an Access 2000 database to allow certain users read/write access to certain tables and/or fields and other users read access to all but write access to certain? Thank you.

Topic

Access 2000 Security

In reply to Access 2000 Security

Firstly you cannot have user level security on individual fields. This is achieved by creating different forms for different users or by writing code to change the .enabled property for txt boxes etc depending on whom has logged in. If people workdirectly on Tables then you must create single table queries that only allow access to the right stuff for each type of user.

Next use the Access User Level Security Wizard under Tools and Security.

When completed it will create another secured MDB file with it’s own mdw (Workgroup Information File) file and a report. Do not ever lose your original database or you can never re-create a secured copy of the database and if the mdw is lost or passwords forgotten you are… stuffed.

Each users version of access will have to be told which mdw to use. Type mdw into Access help for information on this.

It will take several attempts at the wizard to get it right as you will keep creating new queries, forms etc etc until you have the security sorted.

I have done this several times and it’s not pretty at all. My prefferred solution was always to create slightly different front end mdb’s each connected to one backend mdb and use network security to stop users having access to each others frontends.

Access 2000 Security

In reply to Access 2000 Security

Poster rated this answer

Access 2000 Security

In reply to Access 2000 Security

This question was closed by the author

[Author]

Replies