"this file is required for startup" system.mdw restricted user

[mert]

I am running Access XP on a Windows XP computer. When I change the user to be
a restricted user, I can no longer run Access. It asks me to log in, then
gives me an error of "Can't find file c:\documents and
settings\username\application data\microsoft\access\system.mdw. This file is
required for startup"

It increments the system.mdw file each time I try to run (system1.mdw,
system2.mdw, etc.).

I need the user to be restricted, but also to run the application. This
worked before we moved to Active Directory.

 

[Olduke]

When you set up security in Access, the security settings (User IDs, User
Groups, Passwords and Permissions) are saved by default in a file called
System.mdw

System.mdw normally resides in the Windows/System folder on your computer.

The System.mdw on my computer is different than the System.mdw on your
computer. Why? I have different software, settings and set up than you do.

The way to go is to create a new .mdw file (different name than “Systemâ€)
which is in the same folder as the database. This file will contain your
security settings for that specific database. You have to place this new
..mdw in the path on your shortcut to the database so that anyone who opens
the database will have to enter their UserID and Password.

Don’t forget to return the settings to System.mdw when you close the
database.

 

[mert]

I don't understand what you mean. I don't want them to have to enter their ID
and Password when they start up the database. I want the database to open
without them having to enter ID and password.

Even so, I don't know how I would create a mdw file. We've never done this
for our databases and I'm not having any trouble with this except this
database and this particular user (because they're restricted).

 

[Olduke]

Open the security wizard for the database. Check and see if there have been
any alterations to it. For example: there should only be one user defined
name "Admin".
Don't let the name Admin throw you. In Access the Admin is the default user.