Problem with converting Access 97 to Access 2000

[Siobhan Perricone]

We're trying to convert the last Access 97 database in our department
to Access 2000.

The database is secured, and the problem is that the database owner
hasn't worked for the department for years. So his account has been
gone for a while, and the database no longer has an actual owner.

We have a couple of administrative accounts, and they've been able to
do what was needed to this point, but there are two tables over which
we can't seem to get administrative rights:

MsysModules
MsysModules2

Because we can't seem to get administrative rights to these two
tables, we can't convert the database.

Does anyone have any hints for a way to force the Db to give us
administer rights to these two system tables?

(We've tried importing the data objects into a new Access 2000 Db, but
it's breaking a lot of the forms, etc. I was hoping I could just get
it to convert so I wouldn't have to figure out why everything is
breaking when we import it.)

--
Siobhan Perricone
Systems Developer
Vermont Agency of Natural Resources
(my comments are my own, not my employer's)

[PaulT]

You may be able to create another .mdw file to associate the DB to use
so that you can get to those items. CAUTION, you may want to work with
a COPY of the current database when you go to create another .mdw
file. If you're not comfortable with .mdw files (i admit that I
haven't created any of these myself), but I found step to do so here:
(see user TBArpi comments)

http://216.239.41.104/search?q=cache...22+admin&hl=en

-PT

Siobhan Perricone <si***************@nostatespam.vt.us> wrote in message news:<dj********************************@4ax.com>. ..

We're trying to convert the last Access 97 database in our department
to Access 2000.

The database is secured, and the problem is that the database owner
hasn't worked for the department for years. So his account has been
gone for a while, and the database no longer has an actual owner.

We have a couple of administrative accounts, and they've been able to
do what was needed to this point, but there are two tables over which
we can't seem to get administrative rights:

MsysModules
MsysModules2

Because we can't seem to get administrative rights to these two
tables, we can't convert the database.

Does anyone have any hints for a way to force the Db to give us
administer rights to these two system tables?

(We've tried importing the data objects into a new Access 2000 Db, but
it's breaking a lot of the forms, etc. I was hoping I could just get
it to convert so I wouldn't have to figure out why everything is
breaking when we import it.)