Link to home
Start Free TrialLog in
Avatar of slgoetze
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"
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

try saving a copy with .accdb extension, see if you will still get the message
Avatar of slgoetze
slgoetze

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?
Like a new or modified table or data?
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.
By data, I mean new records not a table definition change.
can you upload a copy of the db?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ImpStudentDups seems to cause the problem...
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...
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
I will but it is a challenge because of auto number.
don't you have any backup db?
No. We keep a rolling 5. User ran 5 when getting error.
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.
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
Sorry but I do not see request attention.
it is on the lower right portion of the box where you posted your original question.