Home All Groups Group Topic Archive Search About

copy an access database along with its security to test it

Author
6 May 2009 10:30 PM
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.

Author
7 May 2009 2:50 AM
Tom van Stiphout
On Wed, 6 May 2009 15:30:06 -0700, Mike
<M***@discussions.microsoft.com> wrote:

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


Show quoteHide quote
>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.