slgoetze
asked on
"this object requires a newer version of the microsoft access database engine"
When compacting a 2010 .mdb get message, "this object requires a newer version of the microsoft access database engine"
try saving a copy with .accdb extension, see if you will still get the message
ASKER
Thank you but same problem. I have over 200 sites using Win 7 (64 bit), MSA 2010 (32 bit) without problem.
did you add something to the original db?
ASKER
Like a new or modified table or data?
yes
ASKER
Data, yes.
what was the Data type that was added?
if the data type is only available for the newer version of access, you will definitely gat the error you are getting now.
if the data type is only available for the newer version of access, you will definitely gat the error you are getting now.
ASKER
By data, I mean new records not a table definition change.
can you upload a copy of the db?
ASKER
Sure.
chip2000_be.zip
chip2000_be.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ImpStudentDups seems to cause the problem...
Create a new database and import your objects from the problematic database...
Restore table ImpStudentDups from a backup....
Create a new database and import your objects from the problematic database...
Restore table ImpStudentDups from a backup....
Sorry Rey for "double" posting...i didn't refreshed the page...
ASKER
Is there a way to delete the bad table?
why delete it and keep a corrupted database when you can simple transfer them to a clean one....
no, it will not allow you.. so just do what I posted
ASKER
I will but it is a challenge because of auto number.
don't you have any backup db?
ASKER
No. We keep a rolling 5. User ran 5 when getting error.
ASKER
Thank you for your help finding the "bad" table. How did you do that? We will forge forward.
oh. well to bad. you can search from the web for company that repair corrupted db.
slgoetze,
I was the one who provided the solution to you and you accepted a different post.
I was the one who provided the solution to you and you accepted a different post.
ASKER
Sorry. I noticed that after too late. Do you know how I can correct?
click on request attention and give your reason to reopen the thread
ASKER
Sorry but I do not see request attention.
it is on the lower right portion of the box where you posted your original question.