Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    97 database error message (97)

    I am getting this message when trying to open a database. Microsoft jet database could not find the input table or query MSysModules2. Check path...

    It is not a secured database. I can not get it to open at all.

    Please help!

    Thanks,
    Deborah

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 97 database error message (97)

    Try the following:
    - Create a blank new database.
    - Select File | Get External Data | Import...
    - Try to import all database objects (tables, queries, forms, ...) from the problem database into the new one.
    - If you succeed, set the startup options (Tools | Startup...) as in the problem database, and if necessary, set non-standard references in VBA.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 97 database error message (97)

    Is there a way to import all objects at one time?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 97 database error message (97)

    You'll have to click Select All in each tab. When you have done so, you can click OK to import all database objects in one go.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 97 database error message (97)

    Now, I am getting another message. Operation Invalid without a current undex.

    What do I do now?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 97 database error message (97)

    Your database appears to be seriously corrupt. One other thing you can try: download the JetComp utility from here. See if you can use it to create a repaired version of the database.
    If not, you'll have to restore a recent non-corrupt backup copy of the database.

  7. #7
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 97 database error message (97)

    Thanks...I know the networking guys are going to love this!

    Have a Merry Christmas!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •