The MDB file cannot be opened in an English system...

If the software is not tested, there must be bugs. It is a famous saying. No, I made a Korean software for the customer. I think that I have done a lot of similar multi-language software, no problem... As a result, when the customer uses Windows XP in English version, it will crash !!... Immediately suspect that the customer's character is not good, and let the other party try another machine, the result is still a crash .. If you change to the Chinese version of Windows XP, there is no problem at all.
Ah, even if the customer's character is really bad, I have to help others solve it. So I had a good time searching on the Internet and finally found Windows XP in English on verycd and installed it on the virtual machine, install my program, run it, but there is no crash, but there is an error message "Selected collating sequence not supported by the operating system", and no MDB file can be opened .. Finally realized that the customer was innocent.
In Google, I quickly found someone who encountered such a problem. According to this article, I modified all the MDB files ..

Http://hi.baidu.com/chunyingsmile/blog/item/06efb8526222650f0cf3e37e.html

Problem generation:

A set of software developed in Chinese language.

Userrst. Open "select count (username) as CNT from usertable", adocnop, adopenstatic, adlockoptimistic, adcmdunknown

When connecting to a database

Userrst. Open "select * From usertable where username = '" & txtusername. Text & "'", adocnop, adopenstatic, adlockoptimistic, adcmdunknown

This error message is displayed.

Selected collating sequence not supported by the operating system

Solution:

At first, the sorting method was not supported by the English system, but there was no special sorting for the code. The sorting should be fine. When you browse a Chinese website in the English system, the dialog box for installing the Chinese Language Pack is displayed in IE. After installation, try again. It seems to be a problem with the language system, but we cannot always install a Chinese Language Pack for users (that's too much of a bandit logic ), later, we found that the language packs downloaded from the Microsoft website do not support WINXP installation. Finally, the problem is located on the database itself. Some Chinese information may be used in the database. Looking back at Microsoft's technical explanation, it seems that the default sorting method of MDB files is incorrect, open Database-> Tools-> options-> generally, the sorting order of the new database is obviously in Chinese pinyin. The problem lies here.

Solution 1:

Select the regular sorting order, and then compress the database when it is disabled, or manually compress the database. Otherwise, you must compress the database. Otherwise, you cannot modify this sorting method. The new database will also use this sorting method.

Connect to the database in the English System and pass the test smoothly.

Solution 2:

1) Open my Microsoft Access, open any file, click "Tools", select options, and then select general. Note that there is a new database sort order drop-down box in the lower right corner. Select general. Disable the file. (Note: options can be used only when a file is opened)
2), and then "file" --> "New... "Create a blank data file, and then" file "-->" Get external data "--" import ". Open my old database file and upload all the tables to the new file, then save the new file. I want to do this because I already have a lot of data in my forum. I don't want to start from scratch. If you encounter such problems when creating a forum or system, you can create a new table or use SQL query to write initial data.
3) Save the new file and upload it to the server.

Test, test, what an important test, but I am too lazy to be surprised recently. I often make such mistakes...