Transfer ownership of an entire database to another administrator

Transfer ownership of an entire database to another administrator

  1. Start Microsoft Access by using a secure workgroup that contains the user account that you want to own the database and its objects.

  2. Log on by using that account.

  3. Create a new blank database.

  4. Import all of the objects from the database that has the ownership you want to change into the new database.

    How?

Note   To import a database, you must have Open/Run permission for the database, and Read Design permission for its objects. To import tables, you must also have Read Data permission. If you have permissions for some tables, queries, forms, reports, and macros but not others, Microsoft Access imports only those objects for which you have permissions.