Remove Workgroup / Security Permissions?

[Richie2837]

Hi,

I've created a duplicate of our database in order to be able to work on the design of it from several locations. At present the database which is being used has been split into FE (on local machines) & BE (on server), with a .mdw file for the workgroup settings.

For the duplicate I have created a new database with all the Tables, Queries, Reports, Forms, Macros and code copied from the FE & BE files into a single file. My question is, to be able to work on this from remote machines / pass it on to others to work on the design, do I need to have a copy of the MDW present with the duplicate, or is it possible to remove the workgroup and security permission settings?

 

[Dennisk]

a copy of a workgroup protected db still requires an MDW, but it is very easy to unprotect a file, simply give the Admin user and the Users group full permissions on all objects in the database.

 

[Richie2837]

Thanks Dennsik,

So will I have to have a copy of the mdw along with the db in order to work on it, once I have changed all the user permissions?

 

[Dennisk]

once you have unprotected your db the mdw is no longer required.