Logins and mdw file

W

WSF

Access 97
I have three Access programs (MDE) running on a variety of PC's
throughout the office.

In one case all three are running on one PC.

Usually any Access program asks for the Access login and password,
presumably determined by the joined system.mdw file.

But in this case two of three do require an Access login, but the third
does not. It merely goes past the login and straight into the opening form.

I am CurrentUser in parts of the code.
In the case of this program it seems to log itself on as "Admin" and
this creates problems.

I have joined to the system.mdw file okay, only to find the "join" has
disappeared next time I run the MS Access Workgroup Administrator program.

Help please.

Cheers,
WSF
 
R

Rick B

FIRST, your files are not secured. If you can get in without a login, then
there is NO security on your databse.

Creating userids and passwords in an MDW file DOES NOT secure the file.

You need to make backup copies of your files, then read the security FAQ.
After you have read it (at least once) you should then follow ALL steps IN
ORDER.

SECONDLY, none of this should be done on the SYSTEM.mdw. That is your
default workgroup. Everyone has one of them. You need to create a new
secured workgroup nad store it in the same shared folder as your database
files. This is the workgroup that your files should be tied to. If someone
does not have that file, they should not be able to open your databases.

Read and re-read the links below...

--
Rick B


Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
 
Top