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.
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.