 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / August 2008language issue with DoCmd.TransferDatabase
Hello, One of our users reported this error: DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=DB2;UID=xxxxxxxx;PWD=xxxxxxxxx;DBALIAS=DB2", acTable, "U.D604_RO", "U_D604_RO", , True Works OK when the Office language/locale is set to English. Fails with error "type ODBC Database niet gekend" (type ODBC Database unknown) when the Office language/locale is set to Dutch. I'm not familiar with Access so if anyone could please enlighten me it would be very much appreciated. -- Amedee hi, yes, localized access version requires localized name for "ODBC Database". I use the following code to determine, in my case for Russian version: On Error Resume Next DoCmd.CopyObject 'generate an error Select Case left(Err.Description, 1) Case "В" 'starts with Russian letter strResult = "Базы данных ODBC" Case Else strResult = "ODBC Database" End Select Perhaps there is a better way, but this works ok for me  SignatureBest regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com > Hello, > [quoted text clipped - 13 lines] > -- > Amedee On 17 jul, 14:02, "Alex Dybenko" <alex...@PLEASE.cemi.NO.rssi.SPAM.ru> wrote: > hi, > yes, localized access version requires localized name for "ODBC Database". I [quoted text clipped - 9 lines] > End Select > Perhaps there is a better way, but this works ok for me Thanks, but "ODBC Database" in English is also "ODBC Database" in Dutch. So I think there is a different problem. By the way, I like your style. Intentionally throwing an error to find out the language. Kung-fu code :-) hi, then check ODBC connection string, perhaps it differs in Dutch environment SignatureBest regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com On 17 jul, 14:02, "Alex Dybenko" <alex...@PLEASE.cemi.NO.rssi.SPAM.ru> wrote: > hi, > yes, localized access version requires localized name for "ODBC Database". [quoted text clipped - 10 lines] > End Select > Perhaps there is a better way, but this works ok for me Thanks, but "ODBC Database" in English is also "ODBC Database" in Dutch. So I think there is a different problem. By the way, I like your style. Intentionally throwing an error to find out the language. Kung-fu code :-) On 17 jul, 17:18, "Alex Dybenko" <alex...@PLEASE.cemi.NO.rssi.SPAM.ru> wrote: > hi, > then check ODBC connection string, perhaps it differs in Dutch environment No, it does not. > On 17 jul, 17:18, "Alex Dybenko" <alex...@PLEASE.cemi.NO.rssi.SPAM.ru> > wrote: [quoted text clipped - 3 lines] > > No, it does not. Today the user is back from holiday. Does anyone have any idea how this problem could be solved? -- Amedee > On 17 jul, 17:18, "Alex Dybenko" <alex...@PLEASE.cemi.NO.rssi.SPAM.ru> > wrote: [quoted text clipped - 3 lines] > > No, it does not. OK, case closed. When writing the full query, the user says he doesn't have the problem. User happy, me happy. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.