Indexing error

[Bill Watson]

I have a serious problem with my database which has
become more and more unstable over the past week. Today,
I rec'd this error message:

Operation invalid without a current index (Error
3019). Set the Index and try the operation again.

This occurs when I try to access the tables which don't
show on the screen at all. The data is still accessible
through the queries, forms and reports, but most of the
dynamic tables that are created thru the forms are not
accessible. Does anyone have any idea how to fix this? Or
what the core problem may be? Any help will be
appreciated.

 

[Graham Mandeno]

Hi Bill

It sounds like your database has become corrupted in some way.

The first thing you must do is take a copy of the MDB file. Then try a
compact and repair (Tools>Database Utilities).

If that doesn't improve things (it just might even make matters worse), make
another copy of the original copy and create a new, empty database. Then
import all the objects (File>Get External Data>Import) from the copy you
have made to the new database.

If this doesn't do the trick, then you have got bigger problems. Check out
this page on Tony Toews web site:
http://www.granite.ab.ca/access/corruptmdbs.htm

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.