run queries automatically without violation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try putting SetWarnings False before you run the query, and SetWarnings True
once it's completed.
 
Back
Top