How do I change Access ownership from <unknown>?

microsoft.public.access.security

12 Apr 2005 10:51 AM

Brutus

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.

12 Apr 2005 11:23 AM

Lynn Trapp

>I can not delete some old outdated files. One reason is that the locked
>file
> (.ldb) was not deleted when the file was closed.

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.

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