Problem with converting Access 97 to Access 2000

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Siobhan Perricone
    #1

    Problem with converting Access 97 to Access 2000

    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)
    Tags: None
    • PaulT
      #2
      Re: Problem with converting Access 97 to Access 2000

      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:XZB-3E1ysGwJ:forums.aspfree.com/archive/t-20441+reset+%22ms+access%22+admin&hl=en


      -PT

      Siobhan Perricone <siobhan.perric one@nostatespam .vt.us> wrote in message news:<djvhn0dcb ivctku9ss7iqecf mltvdmbqfj@4ax. com>...[color=blue]
      > 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.)[/color]

        Comment

        Previous template Next
        Working...