Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Corrupted queries in database

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
All of my quereies in a database are corrupted. the following error message comes up when accessing any or all of them. "QueryName" isn't an index in this table. Look in the indexes collection of the Table Def object to determine the valid index names.

I'm hoping that in "object defintiions that something can be fixed here - but don't know how to open and look a the code for this. Doe anybody have a suggestion how to view.?
 
Can any computer access the database file in any way? I don't honestly understand why yet, but in most the two occurences of that problem I've had, one to three computers on the network have still been able to access the file. If this is the case, I recommend exporting the queries to another .mdb file and replacing the old one with the newly created one.
E-mail me if you need any help what-so-ever, I've had a bit of experience with this and I know how scary it can be...especially if the .mdb is an important one. Good luck!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top