Data Type Not Consistent In MS Access? (Set new field as "TEXT" but system treats it as "Yes/No" field)
- by user3522506
I already have an SQL command that will insert any string in the field.
But it doesn't accept any string, giving me "No value given for one or more required parameters".
But if my string is "Yes" or "No", it will update successfully. And in MS Access, will appear as 0 or -1 even though I set the field as text even in the beginning.
Could there…