Securities and passwords

[Richard Yardley]

I am running MS Access 2000 Windows 98 2nd edition and wanted to experiment
with securities on one of my access databases. I made a copy and placed it
in a temp directory.

I used the Tools>Security>User Level Security Wizard to set up user groups
etc. The wizard put a icon on my desktop to access this database. I clicked
on the icon, entered the password and all was well. I then tried to open one
of my other access databases only to get a Logon screen which never had
apeared before and which would not accept the password created for the
security enabled database.

However, I discovered I could get into the other databases by first opening
the security enabled database, then going to file open within access and
opening the database.

Also if copied to another PC the that prviously had the popup logon window
now opened perfectly as before. How do I remove the Logon window that now
pops up every time I try and open an access database?? I hope this makes
sense, but I feel pretty desperate!!

Thanks,
Richard

[Larry Linson]

Somewhere in that process, you "joined" a Workgroup file, and you haven't
"unjoined" it by "joining" another. In their wisdom, that's the way the
Access developers implemented security; they assume that if you join a
Workgroup file, it should apply to all databases. Personally, it would make
more sense if you only used a Workgroup file for a single database, unless
you specifically meant to use it for another.

I handle this by putting icons on my desktop, including the /WRKGRP command
line parameter (for which, see Help) to specify the applicable workgroup.
Most of them point to the unsecured SYSTEM.MDW that came with the product.
If you have changed that one, then you'll need a fresh, clean copy (like
from the installation CD).

And, I use this as an opportunity to caution others: the Help and menu is
NOT, repeat NOT, sufficient information to secure a database/databases. You
need to visit http://www.microsoft.com/downloads and download the Access
Security FAQ. Access security is somewhat complex, and not for "the faint of
heart".

Larry Linson
Microsoft Access MVP
"Richard Yardley" <rh*@iafrica.com> wrote in message
news:3f********@news1.mweb.co.za...

I am running MS Access 2000 Windows 98 2nd edition and wanted to experiment with securities on one of my access databases. I made a copy and placed it
in a temp directory.

I used the Tools>Security>User Level Security Wizard to set up user groups
etc. The wizard put a icon on my desktop to access this database. I clicked on the icon, entered the password and all was well. I then tried to open one of my other access databases only to get a Logon screen which never had
apeared before and which would not accept the password created for the
security enabled database.

However, I discovered I could get into the other databases by first opening the security enabled database, then going to file open within access and
opening the database.

Also if copied to another PC the that prviously had the popup logon window
now opened perfectly as before. How do I remove the Logon window that now
pops up every time I try and open an access database?? I hope this makes
sense, but I feel pretty desperate!!

Thanks,
Richard