Data Type Conversion

[Lewe22]

why would i be seeing a 'Data type conversion' error when saving records to a table on 1 machine, but when saving the exact same record from a number of different machines it works fine. All machines are running the same version of the database, saving to the same table etc etc.

I'm absolutely stumped.

[missinglinq]

Does the database, in fact, use any of the functions to convert datatypes, like CDate() or CDbl() etc?

The usual culprit, when an app runs fine on some machines but not all machines, is that a reference is missing. Go into any form code module and goto
Tools-References and look for any marked "Missing." Uncheck the missing one, close the dialog box, re-open it and re-check the needed reference.

Linq ;0)>

[Lewe22]

Hi. I just looked into that but there are no references missing....

[missinglinq]

What version/service pack of Access are you running on the machines that work and the machine that doesn't work?

Linq ;0)>

[Lewe22]

I'm not sure, how do i find this out?

[missinglinq]

With Access open, goto Help - About Microsoft Access. The topmost line should say something similar to Microsoft Office Access version SPn. The SPn is the service pack number. You need to do this for the machine that is running the app correctly and for the one that isn't.

Linq ;0)>