Solution to the Access Error Selected collating sequence not supported by the operating system

Yesterday, I uploaded a customer's website to a server in the United States. The local test is normal. ProgramThe following error message is displayed after the upload:

   Selected collating sequence not supported by the operating system.
   After checking, it turned out to be an Access database problem. The main reason is that the rented VM space in the United States uses an English operating system. The access file used by my program is created in the Chinese operating system. According to Microsoft's official website, if access is created in one language and used in another language, this error is prompted.

   The solution is as follows:

   1) Open Microsoft Access, open any file, click "Tools", select "options", and then select "General. Note that "new database sorting order" is displayed in the lower-right corner, and "general" L is selected. Disable the file. (Note: "option" can be used only when a file is opened)
   2) then, "file" --> "New... "Create a blank data file, and then" file "-->" Get external data "--" import ". Open the old database file and upload all the tables to the new file, then save the new file.

   3) Save the new file and upload it to the server.
    4) solve the problem!