Newer Version of Microsoft Jet Database Engine

[Amy E. Baggott]

Here's a weirdness for you! In my Access 2003 database, I have a table that
was perfectly fine on Friday at 12:30 p.m. However, without any changes
being made to the table (at least by anyone who will own up to them)
something happened to it between 12:30 and 3:00 p.m. that prevents it from
opening. When I tried to open the table, it gave me an error message saying,
"This object requires a newer version of the Microsoft Jet database engine."
When I pulled the table from an older backup of the database, it's fine
(although if there were any changes to the data in that table, they are now
lost). None of my other tables are affected. I have two questions on this:

1. What could have caused this, so I can stop it happening again?
2. How can I make sure I have the most recent version of the Jet engine?

 

[Jerry Whittle]

Make a backup first, then try a compact and repairl.

 

[Amy E. Baggott]

Actually, the first indication we had was that when we tried to compact the
database we got an error saying "Cannot find field 'description'" with no
further information. I had to go back to my Thursday backup to find a copy
that didn't have that happen to it. Once I found that, I used Total Access
Detective to find the tables with different data for each database (so I
could keep from losing any changes made since then). Total Access Detective
gave me an error on the corrupted database telling me that the table in
question (tblOrderChanges) couldn't be opened. When I tried to open it,
that's when I got the "requires a newer version of Jet" message. I got the
same message when I tried to delete the table. I copied the data changes
from the more recent version to a copy of the backup, compacted that, and
replaced the corrupted database with the copy of the backup, and that seems
to be working fine. I just can't figure out how it got corrupted in the
first place. I suppose it's just the "secret subroutine" striking again.

 

[Jeanette Cunningham]

Amy wrote

the "secret subroutine" striking again???

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Amy E. Baggott]

The one I suspect is buried somewhere in every Microsoft program. It's
calles "Drive the User Straight Up the Nearest Wall"

 

[aaron.kempf]

how can you reccomend continued use of a database the corrupts
_ALL_THE_TIME_?

Move to SQL Server and spit on anyone that uses Jet.
And then fire them.

-Aaron

 

[Clifford Bass]

Hi Aaron,

A search of microsoft.public.sqlserver.server shows a number of people
who encountered corruption of SQL Server databases.

Clifford Bass