type mismatch error

[Guest]

are there known variable data type incompatabilities between Windows 2000 and
Windows XP when running MS Access 2002 programs? Whenever I run a nightly
process written in Access on an XP machine it runs flawlessly, but when I try
to move it to a win2k server I get data type mismatch errors. For example,
when I try to compare two date values. one from a date/time field from a
table and the other date computed and converted to date with CDate(), I get a
type mismatch error.

Thank you for any help you can give.

Fred Parkinson

 

[Dave Patrick]

This is more than like a missing reference issue. Alt-F11, then Tools
References, look for 'MISSING'. Better to ask them in an access group.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| are there known variable data type incompatabilities between Windows 2000
and
| Windows XP when running MS Access 2002 programs? Whenever I run a nightly
| process written in Access on an XP machine it runs flawlessly, but when I
try
| to move it to a win2k server I get data type mismatch errors. For
example,
| when I try to compare two date values. one from a date/time field from a
| table and the other date computed and converted to date with CDate(), I
get a
| type mismatch error.
|
| Thank you for any help you can give.
|
| Fred Parkinson