How do I make an unsecured copy of my database?

[David Anderson]

I want to experiment with upsizing an Access 2003 application using SQL
Server Migration Assistant for Access (SSMA). The front end of my app
exploits the User-Level Security feature of Access but SSMA will not work
with a secured database. I therefore want to create an unsecured copy of my
front end database, leaving the original version untouched so that it will
still work correctly (I have VBA code that does different things for
different users).

My problem is that I have not looked at User-Level Security since I first
set it up a year ago and I have forgotton most of the details. I would
appreciate some basic guidance on how to create an unsecured copy of my
database.

David

 

[Rick Brandt]

I want to experiment with upsizing an Access 2003 application using
SQL Server Migration Assistant for Access (SSMA). The front end of my
app exploits the User-Level Security feature of Access but SSMA will
not work with a secured database. I therefore want to create an
unsecured copy of my front end database, leaving the original version
untouched so that it will still work correctly (I have VBA code that
does different things for different users).

My problem is that I have not looked at User-Level Security since I
first set it up a year ago and I have forgotton most of the details.
I would appreciate some basic guidance on how to create an unsecured
copy of my database.

David

Make a copy, open the copy as an administrator, give all permissions to all
objects to the default group Users.

 

[David Anderson]

Thanks, Rick.