Security access to SQL

[Guest]

I am running a Access mdb 2003 with security, i want to kill the security
that i currently have on the database without having to redo all the work
that i did to it while it was secure, that is the delimma that i have, then i
want to convert it over to SQL then applie the security.
Will i have to redo all the work to the database if i convert the bak to
mdb, could i import the additions that i made to the back up?

 

[Rick Brandt]

I am running a Access mdb 2003 with security, i want to kill the security
that i currently have on the database without having to redo all the work
that i did to it while it was secure, that is the delimma that i have, then i
want to convert it over to SQL then applie the security.
Will i have to redo all the work to the database if i convert the bak to
mdb, could i import the additions that i made to the back up?

You do not have to revert to a backup copy to remove security. Just do these
steps.

Open the database using an account with full administrator permissions.

Grant full permissions to all objects and the database object to the group
"Users".

Close Access and re-open it using the default System.mdw workgroup file.

Create a new blank database and import into it all objects from your existing
file.

The resulting file will be totally unsecured.