Security

Ask something
Discussion Locked

Microsoft Access Security

0 helpful
1 reply

by milg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How can I activate the Security feature of Microsoft Access to a single database only not affecting the other databases?
I had an experienced before that when I activated the security feature of the Microsoft Access on a database that I'm going to secure, everytime I'll make a new database it will trigger the login dialog box. How can avoid this?

1 reply

by erikdr

I'm afraid not directly. The INIfile of Access and its equivalent registrykeys contain a pointer to SYSTEM.MDA. This is
the user database, and its contents (security or not) define the working of Access for _all_ databases opened with these settings.

So the workaround would be to have the workstations using database X to point to a different SYSTEM.MDA (folder on server) than the workstations using databases Y and Z.
In case one workstation needs both, you need to switch to tricky mode - run a small regedit file just prior to opening each database, switching between the pointer to the other MDA file. An alternative, but I used this in the old 2.0 version and am not sure whether it's still possible in 97 and 2000, is to define which SYSTEM.MDA will be used on the commandline invoking MS-Access. Then the registry value is not important because it will be overruled anyhow.

Hope this helps,

- The Netherlands - former Access AppDeveloper...

This discussion is closed to new replies.