Home All Groups Group Topic Archive Search About
Author
4 Dec 2008 7:54 PM
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

Author
5 Dec 2008 6:04 PM
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).

--
Joan Wild
Microsoft Access MVP
Show quoteHide quote
"JoAnne Strickland" <JoAnne Strickland @discussions.microsoft.com> wrote in
message news:CD42D63C-BED9-48E4-86D7-72D70F5F04CF@microsoft.com...
> 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