3421 data conversion type error on Win Xp machine 1

[CGSB]

I developed an Access DB which was running fine on Win 98/2K.

Now one of our employees had Win XP installed and she is getting the a 3421 data conversion type error.

I don't know why it won't work on Win XP. Here's some more info to help anyone who can resolve this issue:

- Using the debugger, I found that the error occurs when the system adds boolean data type value to a recordset.
- I thought it may have been a multiple user problem, so everyone closed the DB so I could verify that, but the error still occured.

That's all I have so far. If you need more information, please let me know.

Regards

 

[CGSB]

Nevermind, I figured it out.

 

[Ed2020]

So what was the problem and the solution...?

Ed Metcalfe.

Please do not feed the trolls.....

 

[CGSB]

The XP OS and the MS Access software on that specific machine is French. So when the boolean variable was set to "False" or "True", the system was dishing out "Faux" and "Vrai".

I changed the boolean variable to a string and set the variable to "False" or "True" depending on the users choice. Another option would have been to change the "Yes/No" field in the table to accept 0 and 1 values instead of True and False.

 

[Ed2020]

Aha. Okay, thank you.

Ed Metcalfe.

Please do not feed the trolls.....