gbm33
asked on
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.
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.
ASKER
DatabaseMX: How can I find that out? And what should I do with the information?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Access-2010-Options.jpg
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
We got lucky I guess :-)
mx
mx