Security & a copied database

[AdamO]

I have a sense this may be a basic question, but i would like to make sure.

I have a secured database following Microsoft's recommended guidelines. If I saved this database as a different name or alternatively copied & pasted as a new name, is anything changed particularly regarding security. Is the database exactly the same or are changes made I would need to be aware of.

I appreciate if you import database objects the ownership may need to be checked.

Before distributing this database I want to keep a backup (just in case) and have one I can continually test ideas on.

 

[Autoeng]

You can copy it to another directory and it will be exactly the same unless you have split into a front end and backend in which case the table links will have to be refreshed and that the shortcut will not point to the copy. I usually create a second shortcut that points to my copy as well so that I can work on the copy and not the original.

Autoeng

 

[Taurus05]

Hi,

I have created a secured database (using the user level security wizard). I would like to backup this secured database and use it in another pc (not networked). However I cannot accessed the database in the other PC. What are the things that I should copied (I have copied the secured.mdw, desktop icons)?

 

[Taurus05]

I have found a solution to my problem. Basically u need to use the wrkgadm.exe to join this secured.mdw when u copied the secured database and the secured.mdw into another PC and u can use the database after u login.

I am trying to get a desktop icon to point to the secured.mdw instead of using the wrkgadm.exe to do it so that it will affect only that specific database and not the rest. Anybody have done this before?