Operation invalid without a current index..??? (URGENT)

[nagasrikanth]

hi all...

i didn't understand what is the problem with my database..
when i open the data base...all of a sudden i got a error message like..
"Operation invalid without a current index"..

and all the tables got disapppeared....

Is there any solution for this...????

[Ecniv]

fingers crossed!

Sounds like Access mdb file is corrupt. You may be able to recover it via tools>Database>Repair and compact.

Open access, find that option and try it.

Otherwise I hope where you have stored it backs up that area, if so see if they can retrieve a working copy.

You may be able to import the tables to a new mdb, but the corrupted one probably won't come across/will break the new mdb.

Have a go n post up what happens

[nagasrikanth]

no ecniv..

i hv already tried alll the options...but no use...

im still wondering ..y it happend??

[Ecniv]

I have not tried this, but if you can get an ADO/ADOX connection to the mdb, perhaps you can delete the indexes on the table (including promary key?). This may let you get the data back, and you can always recreate the indexes.

A possibility?