ms-access >
language-error

multiple languages support for mdb (Access file)

The problem does happen very often at international web.
An good Windows ISP shall enable support for multiple 
languages in Windows.
When you are running Access mdb AODBC at your home 
personal own server always running well.
But it is just not work if your MS Access version is 
not English when you Upload your mdb to other country's 
server with other language.
Example: your PC is a Chinese big5 system and therefore 
you have Chinese big5 Microsoft Access but your internet 
web hosting is English server ... English win 2000 or 
win 2003 server.
If these servers do not  Enable Support for 
Multiple Languages in Windows , 
then you will not be able to use adodb.connection

The web hosting will also become useless for these 
Access users. ISP shall know: even if user download a 
English mdb file the PC will automated conver 
it to PC's language. 

set cnn = server.createobject("adodb.connection")
cnn.connectionstring = "provider=microsoft.jet.oledb.4.0;" & _
"data source=" & server.mappath("db.mdb")
cnn.open 
set rs= cnn.execute ("select item1 from atable " )

error received:
----------------------------------
microsoft jet database engine error '80004005' 

selected collating sequence not supported by the operating system. 

/odbc/ifile.asp, line 5 
--------------- error message maybe ------
Invalid collating sequence. 
-or- 
Unrecognized database format '<pathname>\<filename>'. 

---------more info-----------
http://support.microsoft.com/default.aspx?scid=kb;en-us;q202150

http://support.microsoft.com/default.aspx?kbid=184988