I have a legacy Access 97 database. It stores a lot of historic information that my users often need to access.
After installation of Access 2010 Runtime on a Windows 7 machine, Access 97 no longer prompts for username and password under one users profile.
It does prompt for username and password for other user profile on the machine.
I have verified that is correctly joined to the system.mdw file.
I uninstalled Access 2010 Runtime, then reinstalled Access 97 and joined the security file again. Still, it does not prompt for username and password. It will open, but the user group has no permissions on the database.