Not being prompted with log on window

[PaulA]

Hi, all -

I have a A2003 database (mdb) being opened throughA2007. It uses user-level security with an MDW file. It is a split database with the tables and MDW file on a shared server location.

For some reason, users are not being prompted to log on even though the database is still being linked to the MDW file (when I go into the user security area in database tools everything looks good). This seems to have just started and there is no obvious reason for it. This is happening for all users.

Would anyone have an explanation why user-secured mdb database isn't prompting for a log on?

Let me know if there is any additional information you need that would help.

Thanks!

Paul

 

[Frothingslosh]

User-level security was depreciated in A2007 and later. You'll need to build your own security implementation, I'm afraid, or convert to SQL Server for security.

 

[PaulA]

We have used user-level security successfully not through Access 2007 exactly but through an Access 2003 meb file opened in Access 2007. Then all of a sudden the users aren't being prompted to log in.

We're not using an accdb file.