*index not found

[Boz]

Access 97, back end database.

I keep getting an error telling me that the index is not valid. (Sorry
can't provide the exact message). When I open the back end database, there
are no tables listed. WHen I try to compact and repair, error message. I've
tried using jetcomp and that won't work either. Help...I need to recover
these tables. ALso, what causes this to happen so I can let the users know
what NOT to do.

Thanks,

Linda

 

[Jeff Boyce]

Linda

Have you tried creating a new Access .mdb file and importing tables from the
back-end?

Have you tried opening a copy of the back-end and unchecking both System and
Hidden checkboxes in the Tools|Options window?

Do you have a backup copy?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jerry Whittle]

No tables show on the BE? Sadness. Sounds like major corruption and a recent
backup may be the only solution. Below are some good resources for corruption
issues.

Aside from corruption, it's possible that you are looking at the wrong mdb
file for the BE or someone deleted all the tables in the BE. I would password
protect the BE in the future, assuming it's not secured now, and give the
password to very few people. However as you are getting the error message, I
bet that the problem was caused by corruption.

Also what size is the mdb file after the compact and repair? If under 100kb,
there's nothing to recover as that about the size of a new, blank A03
database file. If significantly above 100kb, there still might be data in
there.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Tony Toews]

I keep getting an error telling me that the index is not valid. (Sorry
can't provide the exact message).

If the following is your message then see the excellent work Dirk did
on this problem.

'AO Index' is not an index in this table
http://groups.google.ca/group/microsoft.public.access/msg/27de5657eebfdde3?hl=en&

When I open the back end database, there
are no tables listed. WHen I try to compact and repair, error message. I've
tried using jetcomp and that won't work either. Help...I need to recover
these tables.

You can also try importing into a new MDB.

ALso, what causes this to happen so I can let the users know
what NOT to do.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

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

 

[DataNumen, Inc.]

Hi,

You can try our product Advanced Access Repair to repair your PST file.
It is a powerful Access recovery tool. It can recover deleted tables
and records in Access databases.

Please visit http://www.datanumen.com/aar/index.htm for detailed
information about Advanced Access Repair.

And you can also download a free demo version at
http://www.datanumen.com/aar/aar.exe

Alan Chen
DataNumen, Inc. - World leader in data recovery technologies
Website: http://www.datanumen.com
Fax: +1-800-9917-FAX (US Toll-Free), +852-31829286 (HONG KONG)