I can only recommend that you download the Security FAQ from
http://support.microsoft.com/kb/207793/en-us. It is many pages, and it
contains no filler-material (all the content is information). Read it,
study it, and repeat... then try out what you think you know on a _copy_ of
your database.
Be prepared to make a few mistakes, from which you recover by making yet
another copy of the original, and continuing with your exploration.
There could be other reasons, but my first guess as to the cause of what you
are experiencing is that you developed the database while not logged in to a
/ the Workgroup file, so you were under the default login of "Admin", thus
making Admin the owner... the owner can always get in... and, when you moved
to another folder, you were using Access again with the default user id of
"Admin" so you could, of course, get in.
There is a step in the FAQ for changing ownership of the database to a
userid that is in the workgroup file.
Again, that may not be your problem, so read the FAQ carefully, follow it
carefully (miss a step and you may end up with a database so insecure that
anyone can get in, or one so secure that even you can no longer get in).
I don't like "joining workgroup files", so place an icon on the user's
desktop with command line statements that open the database with the
appropriate workgroup file... and do the same for any secured databases I
have on my machine, too.
Larry Linson
Microsoft Access MVP
"Edmund" <la*******@yahoo.comwrote in message
news:ZAmfi.8983$tB5.8881@edtnps90...
>I hope someone can help me out set up the security properly.
I have Microsoft Access 97 and Access 2000 in my computer and I developed
my database with Access 2000 with the updated patch SP-3.
I had no trouble to create a workgroup and successfully to run the
security wizard and the group permissions. Everything seemed to work fine
as expected as long as both mdb and mdw files were in the same folder.
Unfortunately, the problem came up when I renamed or moved the folder and
did not join the workgroup to the specific folder. There would be no more
log-on prompt when I opened up the database. In order words, people would
be able to make a backup copy and open it up in any computer with the
default (or any) workgroup file.
I checked the default user group and the permission had been completely
removed (after running the security wizard). The default admin account was
no longer with the admins group.
I even followed Microsoft recommendation to create a new empty database
and import all objects from the secured database in order to work around
the security issue with the Access 97. So far, none of measures was
successful.
Anyone can shed the light on the issue?
Thanks