Corrupted 97 Database

[Guest]

Hello All
Corrupted Access 97 Database
This problem I haven’t seen before

The database opens fine (except for an index error) for the uses and all
reports and forms function well
Data entry works, saves and updates to the tables work also

When I press F11 or hold the shift key down on opening the db I CAN’T SEE
any of the objects in the database, ex forms, queries etc..
So I can’t edit anything or make updates

I’ve tried jetcomp.exe and decompile, nothing works
I can’t link a new database to the corrupted one

Any ideas on what to try next??

 

[Tony Toews [MVP]]

The database opens fine (except for an index error)

What is the exact wording of that index error message? We need
specifics.

That said I strongly suspect it is one of the two following messages

MAKE A BACKUP AND A COPY OF YOUR DATABASE FIRST

'AOIndex' is not an index in this table. Although I don't recall if
we were seeing this message back in A97 days now that I think about
it.

Now see
http://groups.google.ca/group/microsoft.public.access/msg/27de5657eebfdde3?hl=en&
There is also sample code at Recovering from corruption (near the
bottom)
http://allenbrowne.com/ser-47.html

or

"'databasename.mdb' isn't an index in this table. Look in the Indexes
collection of the TableDef object to determine the valid index names."
ACC: Jet Database Engine 3.x Error Messages Due to Corruption -
182867. http://support.microsoft.com/?kbid=182867 These two messages
in Access 97 can usually be fixed by downloading the latest version of
Jet 3.51. Jet 3.5 SP 3
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q172733 This
problem also existed in Access 95 but hopefully no one is still using
that version of Access.

Now if this one fixes your problem the please ensure you have the
latest Jet DLLs on your system.

What I've done is use the various API calls available and am checking
the version number and date/time of a crucial dll, msjetxx.dll, to
ensure it matches what I have on my system. See the Verify
Appropriate Jet Service Pack is installed page at my website for more
details including sample code:
www.granite.ab.ca\access\verifyjetsp.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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

Tony,
Thanks for your reply
1:
Error on opening: "Operation Invalid without a Current Index"
Then I click ok, next error, "Unexpected error (3015) Jet Error
Click Ok

2: Open db and hold shift key down, to go into db window
Give error message "Isn't an index in this table" each time I choose a
different tab
like forms or reports get the same error message!
No Objects listed, no forms, queries, tables etc...

But the users can open this db fine and enter data, it works for the users
fine
I just have not way to make changes

So I can I crack into this db so I can make changes or import all the
objects into a new clean db structure
Thanks again,
David

 

[Tony Toews [MVP]]

1:
Error on opening: "Operation Invalid without a Current Index"
Then I click ok, next error, "Unexpected error (3015) Jet Error
Click Ok

Darn, neither of my replies was what I was expecting.

So I can I crack into this db so I can make changes or import all the
objects into a new clean db structure

I'd sure try importing into a new MDB.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Guest]

Tony,
That's the prob, when you import you can't see any objects either and it
gives more error messages etc...
It this beacuse Access security may be in use here?
Thanks