Cannot open database

[Guest]

Hi, Hope you can help... I have an access database on my website (using
Frontpage) I have just compacted/repaired the database after altering the
security levels (following ms help advice) Now I am unable to open the
database and get the following error message: AOIndex is not a table in this
index.

Is there a way I can repair this fault and more importantly retreive the
info that has been placed in the database since the last back-up?

Appreciate any help and advice - as quick as you can!!!

Thanks Anna.

 

[Arvin Meyer [MVP]]

Generally this means that the MSysObjects table is corrupted.

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks Arvin. Unable to retreive the latest info but luckily most of it was
backed up.