Hi,
I run many small update queries when working on various customer files. Numerous times I get the following message asking for continuance of the query. In all cases I select Yes.
-----------------------------------------------------------------------------------
Microsoft Access can't update all the records in the update query.
Microsoft Access didn't update *0 field(s)due to a type conversion failure, 0 record(s) due to key violations, 0 record(s) due to lock violations, and 2 record(s) due to validation rule violations.
Do you want to continue running this type of action query anyway?
To ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click Help."
-----------------------------------------------------------------------------------
* This is just an example of the messages I get. Depending on the file (table) I'm working with, the number of fields or records will vary.
Is there any way that I can prevent these notifications from appearing and just simple have the queries run to their completion? I have already deselected all the confirmations under Options > Edit/Find.
Thanks
Peter
I run many small update queries when working on various customer files. Numerous times I get the following message asking for continuance of the query. In all cases I select Yes.
-----------------------------------------------------------------------------------
Microsoft Access can't update all the records in the update query.
Microsoft Access didn't update *0 field(s)due to a type conversion failure, 0 record(s) due to key violations, 0 record(s) due to lock violations, and 2 record(s) due to validation rule violations.
Do you want to continue running this type of action query anyway?
To ignore the error(s) and run the query, click Yes.
For an explanation of the causes of the violations, click Help."
-----------------------------------------------------------------------------------
* This is just an example of the messages I get. Depending on the file (table) I'm working with, the number of fields or records will vary.
Is there any way that I can prevent these notifications from appearing and just simple have the queries run to their completion? I have already deselected all the confirmations under Options > Edit/Find.
Thanks
Peter