Index Not In This Table - Error 3800

[Guest]

Environment Window XP Pro - Access 2003 (2000 file format)

I get the following error when a try to open me FE:

A0Index is not an index in this Table.
Selecting Help says it is error 3800.

The problem, I have never had an index as named A0Index.
This is my master FE, my backup from 2 hours earlier works fine,
as do the FE's located on local PCs. My concern is what caused
the error when I did not make any changes and I am the only one
that make changes.

As always, your help is appreciated.

 

[Dirk Goldgar]

In

Environment Window XP Pro - Access 2003 (2000 file format)

I get the following error when a try to open me FE:

A0Index is not an index in this Table.
Selecting Help says it is error 3800.

The problem, I have never had an index as named A0Index.
This is my master FE, my backup from 2 hours earlier works fine,
as do the FE's located on local PCs. My concern is what caused
the error when I did not make any changes and I am the only one
that make changes.

As always, your help is appreciated.

It's "AOIndex", not "A0Index". That's a sign of a particular sort of
database corruption, but I can't say what happened to corrupt the
database. You may be able to fix it using the instructions posted here:

http://allenbrowne.com/ser-47.html#AOIndexIsNotAnIndex

Whether that succeeds or not depends on the exact sort of curruption
that has occurred, but it may be worth a try if you've made changes
since your last backup that you don't want to lose.

 

[Guest]

In

It's "AOIndex", not "A0Index". That's a sign of a particular sort of
database corruption, but I can't say what happened to corrupt the
database. You may be able to fix it using the instructions posted here:

http://allenbrowne.com/ser-47.html#AOIndexIsNotAnIndex

Whether that succeeds or not depends on the exact sort of curruption
that has occurred, but it may be worth a try if you've made changes
since your last backup that you don't want to lose.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


Thanks for the help!

 

[Dale Fye]

Dirk,

Had this problem with a 2003 database today and your FixBadAOIndex routine
worked great.

Thanks for all the great stuff you MVPs provide.

Dale

 

[Dirk Goldgar]

Dirk,

Had this problem with a 2003 database today and your FixBadAOIndex routine
worked great.

Thanks for all the great stuff you MVPs provide.

You're welcome, and thanks, Dale, for letting me know that it worked for
you.

 

[Artie73]

I used this fix and it worked. Thanks alot.

In

It's "AOIndex", not "A0Index". That's a sign of a particular sort of
database corruption, but I can't say what happened to corrupt the
database. You may be able to fix it using the instructions posted here:

http://allenbrowne.com/ser-47.html#AOIndexIsNotAnIndex

Whether that succeeds or not depends on the exact sort of curruption
that has occurred, but it may be worth a try if you've made changes
since your last backup that you don't want to lose.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Art M]

WOW, EXCELLENT !!!
Worked for me !!
Thanks.
Art

In

It's "AOIndex", not "A0Index". That's a sign of a particular sort of
database corruption, but I can't say what happened to corrupt the
database. You may be able to fix it using the instructions posted here:

http://allenbrowne.com/ser-47.html#AOIndexIsNotAnIndex

Whether that succeeds or not depends on the exact sort of curruption
that has occurred, but it may be worth a try if you've made changes
since your last backup that you don't want to lose.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)