Logon doesn't appear when running under Access Runtime 2003

[Guest]

We have packaged an Access file to run via Access 2003 runtime, using the
Package Wizard.
We used to use an MDA file to control permissions within the database, but
have since changed to an MDW file.

The resulting exe file runs normally on a computer with Access 2003
installed, but when I run it on a computer using the Access 2003 runtime and
office 97 installed, the Logon dialog box does NOT appear and it gives the
user access to everything.

Did I miss something in the setup?

 

[Douglas J Steele]

Anytime using the wrong MDW file gives users complete access to the
database, that's a sign that security wasn't applied properly in the first
place.

I suspect that you forgot to remove the default Admin Id from the Admins
group.

I'd advise downloading the Security FAQ from
http://support.microsoft.com/?id=207793, reading it carefully a couple of
times, and reapplying security, making sure you don't leave out any steps.