Help with corrupt database

[Guest]

Access 97

My database is truly FUBAR. The forms all have data. The reports print.
Everything works....except....when I go to the database window, everything is
blank. No tables, no queries, no forms, nothing. The buttons for New, Open,
and Design are even blank. When I click on the Table tab, i get an error
message that says Operation invalid without a current index. Clicking on the
Query tab results in the following message:

"isn't an index in this table. Look in the Indexes collection of the
TableDef object to determine the vaid index names.

The same error message appears when I click on the Reports and Macro tabs.
The Forms tab give no error message, but again, there are no forms listed.


This database stopped working at another facility. I had them zip and
e-mail to me. It took over 2 hours for the e-mail to save to my flash drive.
Just in case the problem was with the zip, I remoted into their system and
still got the same responses.

Any help you can provide would be greatly appreciated.

BTW--I am able to open and use other databases on the same computer. I also
moved the file to my laptop and still have the same problem.

 

[Douglas J Steele]

See whether there's anything of use to you in Tony Toews' Corrupt Access FAQ
at http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Tony Toews]

When I click on the Table tab, i get an error
message that says Operation invalid without a current index. Clicking on the
Query tab results in the following message:

"isn't an index in this table. Look in the Indexes collection of the
TableDef object to determine the vaid index names.

From http://www.granite.ab.ca/access/corruption/symptoms.htm

3019 - "Operation invalid without current index"
3015 - "'databasename.mdb' isn't an index in this table. Look in the
Indexes collection of the TableDef object to determine the valid index
names."

ACC: Jet Database Engine 3.x Error Messages Due to Corruption -
182867. These two messages in Access 97 can usually be fixed by
downloading the latest version of Jet 3.51.

Updated version of Microsoft Jet 3.5 available for download
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q172733

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm