UNICODE problem with ACCESS 2000

G

GTR

I went thru a lot of iformation but nothing solv my Problem so thanks
for people helping.
Devopping a small Access 200 application ( one table, two forms and on
one of these form a button to open the other form. Everything done with
the assistants.
This is developped on a machine entirely set up in french.
When i want to load this application on a machine, set up with Windows
XP and access 2003 in english and with parameter for non unicode
programs set at Bulgarian. the first form is opening and the the button
on this form is not working with the following error message "Problem
within the communication between MS ACCESS and OLE server or ActivX
control".
Some one to help ?
Thanks in advance
Gilles
 
K

K_Mueller

If you create a Access application for international use, you must make it
with a english Access version. The problem are "non ANSI caracters" in the
name of controls.

By default Access (english version) use for the section name in a form or
report:
FormFooter or ReportFooter

In a german version Access use by Default:
Formularfuß or Berichtsfuß

In a german version is the "ß" the problem, in a french version I think
there are "é" or "è" caracters in the Name of the Detail section?

Install an english version of Access and rename the controls with ANSI
caracters. Then make reimport of the forms/reports with:

Sub FormSaveAndLoad(frmName As String)
'Export und Import Frorms
SaveAsText acForm, frmName, "c:\Temp\" & frmName & ".TXT"
LoadFromText acForm, frmName & "1", "c:\Temp\" & frmName & ".TXT"
Kill "c:\Temp\" & frmName & ".TXT"
End Sub

Sub ReportSaveAndLoad(rptName As String)
'Export und Import Reports
SaveAsText acReport, rptName, "c:\Temp\" & rptName & ".TXT"
LoadFromText acReport, rptName & "1", "c:\Temp\" & rptName & ".TXT"
Kill "c:\Temp\" & rptName & ".TXT"
End Sub

Remove the old forms/reports and rename the new forms/reports (remove the
"1").

Klaus Müller
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top