How do I change Access ownership from <unknown>?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can not delete some old outdated files. One reason is that the locked file
(.ldb) was not deleted when the file was closed. Another I believe is
because the ownership for the database is shown as <unknown>. This ownership
is shown for other features such as tables, forms, ... which I can change to
'Admin' but can't do it for database.
 
I can not delete some old outdated files. One reason is that the locked
file
(.ldb) was not deleted when the file was closed.
Click to expand...

This is most likely due to someone improperly exiting Access (often using
Ctrl + Alt + Del).
Another I believe is
because the ownership for the database is shown as <unknown>. This
ownership
is shown for other features such as tables, forms, ... which I can change
to
'Admin' but can't do it for database.
Click to expand...

Create a new blank database, to which you log on as the user that you want
to own all the objects. Import all objects from the old database to the new
one.


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Back
Top