Access 2010 Error: Selected collating sequence not supported with the specified file format

When Compacting and Repairing Databases the error: "Selected collating sequence not supported with the specified file format" occurs. I have compacted and repaired the two databases previously with no problem. This phenomenon has just begun to occur. One database is a conversion from 2000 but the other one is a fresh 2010 MDB.

The information I garnered so far has to do with upgrades of MDB's but none to 2010. Even then it does address the issue of the error occurring in a new 2010 database.

The databases are on a Win XP SP3 computer.
gbm33Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
For A2010 ....

File Tab >> Options >> General >> New Database Sort Order.
The default for a new A2010 is General - Legacy.

mx
1
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
What is the collating sequence for the db in question ?

mx
0
 
gbm33Author Commented:
DatabaseMX: How can I find that out? And what should I do with the information?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
0
 
gbm33Author Commented:
DatabaseMX: That did the trick. The New Database Sort Order was set to General rather than General - Legacy. However the look of Access 2010 is somewhat different.
Access-2010-Options.jpg
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes, fortunately I know have a dedicated A2010 system here at work ... just couldn't get a screen shot just yet.

We got lucky I guess :-)

mx
0
All Courses

From novice to tech pro — start learning today.