By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 834 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

Data Type Conversion

P: 94
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.
Sep 9 '08 #1
Share this Question
Share on Google+
5 Replies


missinglinq
Expert 2.5K+
P: 3,532
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)>
Sep 9 '08 #2

P: 94
Hi. I just looked into that but there are no references missing....
Sep 9 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
What version/service pack of Access are you running on the machines that work and the machine that doesn't work?

Linq ;0)>
Sep 9 '08 #4

P: 94
I'm not sure, how do i find this out?
Sep 10 '08 #5

missinglinq
Expert 2.5K+
P: 3,532
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)>
Sep 10 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.