I have a SQL server that is ODBC in my access which is being used as the front end of me I have created a column in SQL with a bit data type and yes / has created a check box with a data type that uses its SQL column as its control source when I go to my form and there is some Try to change also So I and my table would update, I get a writing error and I'm trying not to engage those updates that do. As soon as I delete the bit data type, and the check box, I am able to add the information again on my form. Does anyone have a solution or a way to know that I can use the Boolean check box to report my SQL database so that I can track the progress of an order, but can still add my records? Apart from this, if someone knows why this is happening, then I appreciate the information for my notes and understanding.
This image shows the columns created in SQL Server
This image shows how it looks in Odyssey table in Access
This image shows the control source that I had selected which uses the form combo box, the text box names, and hopefully Check that box
This image shows what I do after updating and closing
thanks
Haven has done it for a long time, but the problem may be related to the numbers which are stored Yes / No entry in = -1/0, sqlsrvr = 1/0 (or similar) You can use an INT field in sqlsrvr which then sends any entry (-1 or 0), or will keep a bit, but do not use yes / no - there is no custom yes / no table where yah = 1 and no = 0 (or whatever bit is needed) and use the custom table as a lookup table for that field, when the updated value will be sent. Hope this is all relevant and understandable.
No comments:
Post a Comment