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

Source: Internet
Author: User
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!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.