Using a database on a PC with different language

[Bannor]

Hi!

I am using MS Access 2003 SP3 to create a small staff database. I have a
table with staff details including Name, Second name and Surname. I also have
a query that returns the Surname & Initials for using on a form (takes less
space than all 3 names). It uses the Text formula 'Left' to return the first
letters of the fields Name and Second name. This query runs fine on my PC (US
English).

The problem starts when I try to run this query on another PC with the
Russian language (also using MS Access SP3 - Russian). Other forms and
queries appear to run without problem, but this query tells me it does not
recognise the formula that returns the initials. I have even tried rebuilding
it on the Russian PC - same problem. I'm completely baffled - what am I doing
wrong?
--
I also receive an error about an incorrect link to "QTOControl.dll" version
1.0 on the Russian PCs (I have tried on several Russian PCs). How can I solve
this problem? Are these 2 problems related?

All PCs are connected to the net and receive all updates.

Philip

 

[Pieter Wijnen]

They are indeed related. You either have to register the dll on the russian
PC (if it is indeed required)
or remove the reference from the db (any module, tools menu references)

Pieter

 

[Bannor]

Wow, thanks very much for the blisteringly rapid response!!

The DLL in question was related to QuickTime according to Access - quite how
this relates to the non-functioning of my text formula in Access I completely
fail to understand. But the main thing is - it appears to have solved my
problem! I simply unregistered it in Access

Thankyou very much indeed!!