Transfer permissions to another database?

shacket

Registered User.
Local time
Today, 23:12
Joined
Dec 19, 2000
Messages
218
I have a database that is constantly "running out of memory" with VBA. I have looked into the problem and it looks like my only option is to create a new database and import all of the objects over from the old one.

My problem is that I have user level security that is somewhat complex and would be quite tedious (though doable) to recreate in this new database.

Since I want the same permissions on the database objects in the new database as the old, is there a way to transfer the objects into a new database (using the same workgroup) and keep all of the permissions applied as they were?

Thank you for any help you can give.
 

Users who are viewing this thread

Back
Top Bottom