Dim the DB As New ADOX. Catalog
The DB. The Create ". The Provider=Microsoft jet. The OLEDB. 4.0; The Data Source=C: \ ABC. MDB; The Jet OLEDB: Database Password="

Create ACCESS database using the above statements, C: \ ABC MDB
With ACCESS to open the database, to build a new table, the new fields, input records, four assumptions are day,,,, between the four words,
Then sorting, sorting result is, the person, day, between, spell initials are respectively between s r t j
What reason is this?? Please help warrior analysis.

CodePudding user response:

The problem seems to be ADOX
Try the DAO compress the database
The Set VCATALOG=CreateObject (" DAO. DBEngine. 36 ")
VCATALOG.Com pactDatabase "C: \ SRC MDB", "C: \ DST MDB," dbLangChineseSimplified

CodePudding user response:

Here I SELECT characters FROM table 5 ORDER BY Chinese characters; Get

Chinese characters



day

CodePudding user response:

refer to the second floor of123 response:

here I SELECT characters FROM table 5 ORDER BY Chinese characters; Get

Chinese characters



Day

Of123 reply is positive solution,