Transfer Chinese Access database to English Operating System

Using localization resources to change your project to an English version is a bit stupid

Test in a local environment without any problem and put it into the English System of the VM.

Okay, there's a problem.

Prompt Selected collating sequence not supported by the operating system

Check the database order on the internet, probably because the database sorting order is incorrect!

The solution is as follows:

1. open access and open any file, tools --> options-> General-> new database sort order-> General, and close the file.

File-"Get external data"-"import" to import the old database. After saving, it will be OK.

Enabled or

2. Select the regular sorting order and compress the database.

 

The final solution is to use method 2, and to clear the data first (the data volume is small) and then compress it. I don't know whether the database effect is the same or not. It is to be verified next time.

As for method 1, if the test fails under local access, an error is still reported, which may be implemented in English. Further verification is required.