Expressions valid on one PC not on others...

  • Thread starter Thread starter Scott A
  • Start date Start date
S

Scott A

I've had problems writing expressions on my development
machine, until I discovered that writing the same
expressions on my home PC worked - and was able to
program the expressions into forms and reports and then
import them into the database on the development machine.

Once imported, the forms and reports work fine on any
machine running Access (2000) at home or work.

So I'm wondering what components are not installed at
work (or are installed and shouldn't be), and am doing
some analysis on the software environment. The variances
I've discovered are:

OS version (5.1.2600 SP1 - Home v 5.0.2195 SP4 - Work)
VBA version (6.03 - Home v 6.03/6.0 - Work)
ADO version (2.7 - Home v 2.5 - Work)
Jet version (4.0.5919.0 - Home v 4.0.6807 - Work)
Access driver (4.0.6019 - Home v 4.0.6200 - Work)

I thought it might be the VBA version, but there's a
machine at work that has 6.3 and won't let me build these
expressions either. I've had Jet SP 4 installed on all
machines at work, which resolved some issues I have had
with some of the VBA code, but hasn't resolved the issue
with creating expressions.

If any of these factors sounds suspicious, or there are
other factors I should check, please let me know.

Thanks,

Scott A
 
I may have found the answer to my own question - but have
never heard anything about it:

My home PC is from the US, while the workstations at the
office are German. My expressions work fine when
programmed from home, as most of the values in the
expressions are separated by commas. When using the comma
key on the German workstation, the expressions generate
errors, until I replace them with semi-colons!

If anyone can point me to a resource that describes this
in more detail, I would be very greatful!

Scott A
 
Back
Top