Home All Groups Group Topic Archive Search About

database owner unknown

Author
20 Oct 2006 1:13 PM
Jamie
I have a Access 97 database that the Database Owner shows Unknown.

I'm trying to upgrade this database.  I have an id that is ADMIN that I have
set as the owner  and admin rights of all the:
tables
queries
forms
reports
Macros
modules

What I still can't set is the owner and rights to the DATABASE.  Problem is
it shows <UNKNOWN>.

I'm pretty sure I know the account that might have this but that account
doesn't exist in the system.mdw anymore.

How do I get it so my admin account is the owner of this database so I may
upgrade it?

Author
20 Oct 2006 2:30 PM
Granny Spitz via AccessMonster.com
Jamie wrote:
> How do I get it so my admin account is the owner of this database so I may
> upgrade it?

Create a new unsecured database and import all the objects from the old one.

--
Message posted via http://www.accessmonster.com