• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 822
  • Last Modified:

"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"
0
slgoetze
Asked:
slgoetze
  • 12
  • 11
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try saving a copy with .accdb extension, see if you will still get the message
0
 
slgoetzeAuthor Commented:
Thank you but same problem. I have over 200 sites using Win 7 (64 bit), MSA 2010 (32 bit) without problem.
0
 
Rey Obrero (Capricorn1)Commented:
did you add something to the original db?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slgoetzeAuthor Commented:
Like a new or modified table or data?
0
 
Rey Obrero (Capricorn1)Commented:
yes
0
 
slgoetzeAuthor Commented:
Data, yes.
0
 
Rey Obrero (Capricorn1)Commented:
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.
0
 
slgoetzeAuthor Commented:
By data, I mean new records not a table definition change.
0
 
Rey Obrero (Capricorn1)Commented:
can you upload a copy of the db?
0
 
slgoetzeAuthor Commented:
0
 
Rey Obrero (Capricorn1)Commented:
the table impStudentDups is the problem.
create a blank db and import all the tables except for the table impStudentDups

then do a compact and repair of the new db.
recreate the table impStudentDups if needed
0
 
John TsioumprisSoftware & Systems EngineerCommented:
ImpStudentDups seems to cause the problem...
Create a new database and import your objects from the problematic database...
Restore table ImpStudentDups  from a backup....
0
 
John TsioumprisSoftware & Systems EngineerCommented:
Sorry Rey for "double" posting...i didn't refreshed the page...
0
 
slgoetzeAuthor Commented:
Is there a way to delete the bad table?
0
 
John TsioumprisSoftware & Systems EngineerCommented:
why delete it and keep a corrupted database when you can simple transfer them to a clean one....
0
 
Rey Obrero (Capricorn1)Commented:
no, it will not allow you.. so just do what I posted
0
 
slgoetzeAuthor Commented:
I will but it is a challenge because of auto number.
0
 
Rey Obrero (Capricorn1)Commented:
don't you have any backup db?
0
 
slgoetzeAuthor Commented:
No. We keep a rolling 5. User ran 5 when getting error.
0
 
slgoetzeAuthor Commented:
Thank you for your help finding the "bad" table. How did you do that? We will forge forward.
0
 
Rey Obrero (Capricorn1)Commented:
oh. well to bad. you can search from the web for company that repair corrupted db.
0
 
Rey Obrero (Capricorn1)Commented:
slgoetze,

I was the one who provided the solution to you  and you accepted a different post.
0
 
slgoetzeAuthor Commented:
Sorry. I noticed that after too late. Do you know how I can correct?
0
 
Rey Obrero (Capricorn1)Commented:
click on request attention and give your reason to reopen the thread
0
 
slgoetzeAuthor Commented:
Sorry but I do not see request attention.
0
 
Rey Obrero (Capricorn1)Commented:
it is on the lower right portion of the box where you posted your original question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 12
  • 11
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now