Copying all objects, data, relationship, and security to a new MDB file

[Leif]

I have a problem with a number of MDBs I created in Access 2003 and now use in Access 2010.

When I right click on the database objects (Tables, Queries, Forms, etc.) The delete option is grayed out. It is not a security thing since I can use docmd.deleteobject from the VBA immediate window to delete objects. Of course, this method is not very convenient. I presume this is an unresolved Access bug in 2010.

Due to this Microsoft bug in 2010 I've read that copying all the objects to a new blank MDB file clears the problem. I've tried this and it works. However, my database uses user level security. I don't know how to make the copy and include the current security. I'm the builder of the database and the administrator so permissions should not be an issue. Could someone tell me how this is done?

Thanks.

 

[apr pillai]

When you import the objects into a new .MDB database the security settings are not transferred. You have to assign them again at Group/User level.

The following procedure works for .MDB databases in Access2007. It may work in 2010 as well.

Open the .MDB File and display the VBA Window.
Run the following Command from the Debug Window:

DoCmd.RunCommand acCmdWorkgroupAdministrator

The Workgroup Administrator program runs. You may JOIN to your existing Workgroup Information File. Assign User Group/User level access rights as you did before.

You may find more details here:DoCmd.RunCommand acCmdWorkgroupAdministrator