views:

16

answers:

1

I recently upgraded to MS Access 2010. When I open a certain .mdb (2000-2003 file format), I am greeted with this message: collating sequence not supported with the specified file format. I'm not sure what it means, but it gives it to me every time the database is opened.

I have Googled around but found nothing that I thought seemed related. If I upgraded the file format to 2007 it didn't give me the message but that isn't much of an option in this situation.

Is this a 2010 issue? or is there something corrupted with my database? What do I need to do to work around it?

+1  A: 

This KB article by M$ fixed my problem. The issue was the "new database sort order" setting.

Icode4food
You should accept your own answer.
David-W-Fenton
Thanks for the reminder...SO makes me wait two days though before I can accept my own answer. I have 55 minutes to go!
Icode4food