Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jun 2002
    Location
    RTP, NC, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Indexing Error (A97)

    For some reason I just got an error "Operation Invalid Without A Current Index" in my database. All of my tables have disappeared from view, but they're still there because all the forms/reports/etc. are still working. I do have the security manager installed, but don't know if it has anything to do with that or not. The other thing I think might have caused it is that I changed a field type from text to memo (and don't know if I turned on the indexing). Any ideas?

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

    Re: Indexing Error (A97)

    1. Make a backup copy of the database as it is now. If things go wrong, make new copies of this one.
    2. Make sure you have installed Jet 3.5 SP3. See <!mskb=172733>Microsoft Knowledge Base Article 172733<!/mskb>
    3. Try Tools | Database Utilities | Compact Database.
    4. If that doesn't help, try the JetComp utility that is part of Jet 3.5 SP3.
    5. If that still doesn't help, try to import as many database objects as possible from the problem database into a new blank database.
    6. If that doesn't work either, try to get the data from the tables into Excel (Data | Get External Data | New Query...)
    7. If you got here, your database is probably lost beyond recovery. Go back to an undamaged backup if you have one.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Indexing Error (A97)

    The error message seems like it would be generated if you tried to use Seek without first specifying an index.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Lounger
    Join Date
    Jun 2002
    Location
    RTP, NC, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Indexing Error (A97)

    I wasn't trying to use Seek, the error occurs whenever I open the database. This sounds like it could get ugly...
    Good thing I have a backup copy!

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Indexing Error (A97)

    >>Good thing I have a backup copy!<<

    Whew!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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