Hello, I have something that is a bit puzzling happening and it has to do with two databases and their security settings. I have one users that uses both databases, however he has different permissions. Some tables and forms in the different databases share the same names. Also, the usernames are the same.

These are two different databases with two different security files and shortcuts. If I open each one of them separately (open one and close access and them open the next one) the permissions are set correctly and the user is restricted to viewing/editing the pages he is supposes to.

However, if the user has one of the databases open and, opens the other one without closing access (goes to "file", and clicks on the recent file list) the 2nd database is opened using the security file from the 1st one, therefore the user ends up with the same rights he had on the 1st database...

Why is it that Access just opens the 2nd database without going to the correct security file to determine the appropriate permissions?

Thanks

Mafhobb

If you have a secured database, it can ONLY be opened from the shortcut because the shortcut target it what is telling the database which security file to use. If you try to open it from within Access, it doesn't know which security file to use, so it tries to use system.mdw, which fails since the database is secured.

If you have a secured database, it can ONLY be opened from the shortcut because the shortcut target it what is telling the database which security file to use. If you try to open it from within Access, it doesn't know which security file to use, so it tries to use system.mdw, which fails since the database is secured.

See, that is what I thought it would happen, but it does not. It actually opens... except that when the 2nd db opens, it opens using the1st db mdw file...

Any idea?

You may not have remove permissions from the admin user in the mdw files.
Here is a very good link - just make sure you didn't skip any steps:
http://www.databasedev.co.uk/access_security.html