Copy over Secured MDB

[Bret]

Please, I need help understanding Security Concept.
I have a secured mdb that is the backend source.
The actual mdb with filled tables is over a gig, so before
I secure the file I create a copy with all records cleaned
out but structure and objects intact, this way the
Security wizard doesnt take forever to create the .bak
file.
Then I copy the actual .mdb into the folder with all its
records thinking the Security will recognize the objects.
What happens is Security is changed, "USER" group now has
all permissions and I lose the ability to administer.
Please help me understand this process and what can I do
to bring into the Secured mdb the actual mdb and retain
Security. much thanks!

 

[Scott McDaniel]

How did you open your database after moving it? If you did so by merely
double clicking the file, and you could open the database without joining
the proper security group, then your database isn't properly secured.

To open your database with the correct security file, build a shortcut with
the "Target" value like this:

"Path to msaccess.exe" "Path to your database" /wrkgrp "Path to your
workgroup file"

This will open your database with the correct workgroup file. Of course, the
same caveat as above still applies: obviously, you didn't properly secure
your database. Download and read the MS Access Security FAQ (google on "ms
access security faq" for the link).

 

[Bruce M. Thompson]

Please, I need help understanding Security Concept.

I have a secured mdb that is the backend source.
The actual mdb with filled tables is over a gig, so before
I secure the file I create a copy with all records cleaned
out but structure and objects intact, this way the
Security wizard doesnt take forever to create the .bak
file.
Then I copy the actual .mdb into the folder with all its
records thinking the Security will recognize the objects.
What happens is Security is changed, "USER" group now has
all permissions and I lose the ability to administer.
Please help me understand this process and what can I do
to bring into the Secured mdb the actual mdb and retain
Security. much thanks!

All of the *permissions* (this is the part that makes Access security work) are
stored in the MDB file - only the workgroup and user information is stored in
the workgroup file. You will need to import all of your tables's data into the
secured version. For more information about Access Security, you should obtain
and read a copy of the Access Security FAQ, available from the following source:

http://support.microsoft.com/default.aspx?kbid=207793