HELP!

[JoAnne Strickland]

There was an existing database in 2003 that I imported to a new one and made
some improvements too. I purposely made a new one to overwrite a very
troublesome security .mdw file. Some network person has been working with
adding new users and I know has run the security wizard. The other day all
users had no permissions to get in the database. Then I went over there and
reinstalled a backup. Checked all users and it opened up with no log in (the
way I wanted it) except for the network. Everything was okay. Now I get a
call that each workstation is getting in or not getting in a different way
from no permissions, to just getting in, to asking for Admin's password. What
is telling each of these workstations to act differently. This is one access
database on a server. Is the computer rebootting and setting the default
security mdw? I don't want one on this database at all. Please help. They are
blaming me and I am thinking it is the network administrator and something
she is doing! Please tell me how to fix this once and for all. If I want
everyone just to log onto the server with password and user name and then no
log in for the users, what do I do so all workstations will work the same way
every time??? Please help!!!!!!!!!!!!!!!!!!!!!

JoAnne Strickland

 

[Joan Wild]

Each PC's copy of Access has a mdw file set as the default one to use. Some
have a secure one (asking for username/password), some have the standard
system.mdw that ships with Access, etc.

You need each PC to rejoin the standard system.mdw that ships with Access.
Tools, Security, Workgroup Administrator...Join and locate the system.mdw
that ships with Access (search for it first, if need be).