run queries automatically without violation

J

juniorreidirie

Hello, I have a series of append quieries which I would like to run with our
returning a key violation error. I have set the primary key in the table in
order to limit the number of new records. Is there a better way to do this or
can someone tell me how to FORCE the yes accept button automatically when the
query returns a violation diologue message. thx.
 
D

Douglas J. Steele

Try putting SetWarnings False before you run the query, and SetWarnings True
once it's completed.
 
Top