User-based security disabled

[PaulA]

I have an Access 2003 db being used through Access 2007 in order to use user-based security. It is a spit db with the be being on a shared server.

For some reason, the security login has been deactivated after working fine for over a year. The user goes right to the autoexec macro file without having to log in.

They are also getting a "Read-Only" message at the top about only being able change table in linked tables.

I have no idea why this has happened. The DB is configured to utilize the logon as a parameter in some queries.

Any ideas what is going on?

Thanks!

Paul

 

[boblarson]

1. Are they opening the database through a shortcut?
2. Did you remember to remove the Admin user from the Admins group (not before adding another one with a different name into that group)?

 

[PaulA]

They are using a short cut (no modifications have been made). Admin is still a member of the Admins group although there are now other users in the group. This has never been a problem before. It has worked fine until this morning.

 

[boblarson]

Admin should NOT be in the Admins group if it is properly secured. The Admin user is the default on EVERYONE'S computer. So, if they don't go through your shortcut, they can get in and do everything the admin user can. So, it needs to be removed from the Admins group. Your database has not been properly secured from the beginning then and it is just now that it has become obvious.

 

[PaulA]

I believe you, but when I tried logging in as admin I got a "Not a valid account name or password."

I will remove the account but will that make things normal again?

 

[boblarson]

I believe you, but when I tried logging in as admin I got a "Not a valid account name or password."

I will remove the account but will that make things normal again?

It will help. And you may need to set the database location as a trusted location ON EACH USER'S MACHINE.

 

[PaulA]

I was sent the program's copy of the MDW file and I also didn't get a log-in although my own copy worked fine.

I'm sending that copy over to them with the adjustment you recommended.

Thanks for your help.