strange corruption

[Gabe]

my a97 database works fine, i can look up records, add records, etc. But
when try to view tables, queries, forms, etc. it gives me the following
error: "isn't an index in this table. Look in the indexes collection of the
tabledef object to determine the valid index names. i can export any object
that i can open, the problem is that i don't open tables, mostly forms and
querys. but i can't import from a blank DB.

I have already done all the repair things, jetcomp, etc.

Please help
Gabe

 

[Allen Browne]

You should be able to create a new (blank) database, and import all objects
except the failed table.

If you can read all data from this table in the bad database, you might be
able to create a query into this table, and then change it to a Make Table
query (Make Table on Query menu, in query design.) Run the query. If
everything works okay, this will give you a new table containing the data
from the bad table, and you may then be able to import the new table.

 

[Gabe]

i get the same error when i try to import from the corrupted DB. i can't
create a query because i get the same error when i select querys.

any other ideas?

thanks,
gabe

 

[Allen Browne]

Are you able to read any records from this table?

 

[Gabe]

i can read all the records in all the tables as long as i go thru the forms i
already have, but i try to look at just the table it gives me the error.

 

[Allen Browne]

What is the RecordSource of the form that lets you read the table?

You should be able to create a query using the same SQL statement, and
export that.

Or, you may be able to loop through the RecordsetClone of the form, and
AddNew to a Recordset created through OpenDatabase into another mdb to
achieve the export.

 

[Tony Toews]

my a97 database works fine, i can look up records, add records, etc. But
when try to view tables, queries, forms, etc. it gives me the following
error: "isn't an index in this table. Look in the indexes collection of the
tabledef object to determine the valid index names. i can export any object
that i can open, the problem is that i don't open tables, mostly forms and
querys. but i can't import from a blank DB.

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. http://support.microsoft.com/?kbid=182867 These two
messages in Access 97 can usually be fixed by downloading the latest
version of Jet 3.51. Jet 3.5 SP 3 This problem also existed in Access
95 but hopefully no one is still using that version of Access.

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