Access Form and MySQL backend...

[Tanya556]

Hello Everyone!

I just recently started using MySQL as a beckend database for an Access 97 application. I have existing forms that where created in Access. Everything is working great except a form that is bound to a table in MySQL. The problem with the form is that I have a checkbox bound to a field with datatype "int". It will not let me insert the value of the checkbox (-1,0) into that field. I keep getting "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. (Error 3163)".

What am I doing wrong? Can anyone help me out with this issue? Thank you in advance for your time.

 

[Bastien]

What is the length and attributes of the field?

If the field is int(1) signed, then you can only have a one character input into the column. So the negative doesn't fit.



Bastien

Cat, the other other white meat

 

[Tanya556]

Hello Bastien,

Thank you for your quick reply.

The length is (2) signed. It set int(2) signed. I am even trying to change the value to "Yes" or "No" with varchar(255) signed and still same error?

Thanks again.

 

[Tanya556]

I figured out what my problem was. Its so stupid I am laughing at myself.

Originally the field datatype was set as varchar(255) and I changed it to int(2). Before I changed it to int(2) the table was already linked to the Access application and it was still being seen as the varchar(255) field. What I did was drop the linked table and re-link it to the application and that worked. I can't believe I spent a whole day on this.

Thank you for your time and your suggestions. They are always helpful.