J
J. Thomas Coons
How can I get validation rule violations in an append
query when the table it appends to does not have any
validation rules? I created a table using a make-table
query. Then I changed the make-table query to an append
query. I added a few more fields to the newly-created
table, but no validation rules. When I run the append
query, I often get validation rule violations, even though
there aren't any validation rules.
Another anomaly: If I add extra fields in the make-table
query in the form "field:Null" so they will be in the
newly-created table, the created fields in the new table
have the data type "Binary". But this isn't even an
allowed data type when creating a table in design view...
The make-table query also creates text fields of size 255,
even for fields that only need one character of text, and
I have to tweak them all to make it run more efficiently...
query when the table it appends to does not have any
validation rules? I created a table using a make-table
query. Then I changed the make-table query to an append
query. I added a few more fields to the newly-created
table, but no validation rules. When I run the append
query, I often get validation rule violations, even though
there aren't any validation rules.
Another anomaly: If I add extra fields in the make-table
query in the form "field:Null" so they will be in the
newly-created table, the created fields in the new table
have the data type "Binary". But this isn't even an
allowed data type when creating a table in design view...
The make-table query also creates text fields of size 255,
even for fields that only need one character of text, and
I have to tweak them all to make it run more efficiently...