password protection

[Rawley]

Ok - I setup a freight database as a protected file. I followed the steps laid-out by access: I used the Workgroup Administrator to setup a freight security workgroup, I setup an admin account and a user account, so that they both have password log-ins and the basic user can't accidentally change or delete the content. My question is this, why can just anyone open the file??? I just installed Access 2003 on another person's computer, and they can open the file without any password protection. I understand they're not on the freight security workgroup, but shouldn't the file still be protected from outside sources? Any help on this would be greatly appreciated!

 

[Peter van der Goes]

Ok - I setup a freight database as a protected file. I followed the steps

laid-out by access: I used the Workgroup Administrator to setup a freight
security workgroup, I setup an admin account and a user account, so that
they both have password log-ins and the basic user can't accidentally change
or delete the content. My question is this, why can just anyone open the
file??? I just installed Access 2003 on another person's computer, and they
can open the file without any password protection. I understand they're not
on the freight security workgroup, but shouldn't the file still be protected
from outside sources? Any help on this would be greatly appreciated!

Did you apply a password to the database itself?
Tools->Security->Add Database Password

Once a password is applied, your database cannot be opened unless the
password is supplied.

Or, am I missing the point?

 

[Rawley]

I did not apply a password to the database itself. I had thought that if I did that, then people would have to enter two passwords to get in. This may be the only solution, though, to prevent people not in that group from accessing the program.

 

[Dan Sweetwood]

Rawley,

Each PC's MS Office Access has to be joined to the same
security file that you created on the original master
database server using the Workgroup Administrator. That
file is *.mdw (whatever you named it) and is usually found
in c:\documents and settings\administrator (or whatever
your acount is)\application data\microsoft\..... If you
search for an mdw file you will find it. Using the
Workgroup Administrator at each computer click on the join
button and then browse to the location of the master
*.mdw file on the server. I placed that file in a shared
folder that was easy to access (no pun intended) and
joined the master database to that file sothat it is
always up to date. That means that the user will be forced
into the security you set complete with the database logon
and access rights once they have opened the database. If
the computers are not networked then you can copy the
file, load it on the computers and join to that file. I
just spent a few days doing the very same thing and it
works like a charm. Good luck!

-----Original Message-----
Ok - I setup a freight database as a protected file. I

followed the steps laid-out by access: I used the
Workgroup Administrator to setup a freight security
workgroup, I setup an admin account and a user account, so
that they both have password log-ins and the basic user
can't accidentally change or delete the content. My
question is this, why can just anyone open the file??? I
just installed Access 2003 on another person's computer,
and they can open the file without any password
protection. I understand they're not on the freight
security workgroup, but shouldn't the file still be
protected from outside sources? Any help on this would be
greatly appreciated!