copy an access database along with its security to test it

[Mike]

How would I make copy of an Access database that already has security in it
to test the database to see if the security works? I would have to change the
data while testing and I don't want to work with the real data. I guess I
would need to copy the shortcut also.

 

[Tom van Stiphout]

On Wed, 6 May 2009 15:30:06 -0700, Mike

You start with a split database: the data is separate from everything
else.
Then generally setting up a beta test version involves creating a copy
of the production back-end (I would also rename it to
[name]-beta.mdb), putting it somewhere else, and reattaching the
tables to it. You'll want to be VERY SURE you are connected to the
beta database.

-Tom.
Microsoft Access MVP