Access Key Violations

[Michael Kintner]

How can I tell access that no matter what error I get to continue anyway
with out having user interaction?

For example: I have a append query and I get the error message: can't append
all records in the append query due to key violations do you wish to
continue? I then click Yes. How can I have access to due automatically
with no user interaction? I have turned off all the confirm options under
the tools options menu but no luck.

Thank you in advance for any help, this has been driving me crazy.
Mike

 

[Roger Carlson]

If you are running the query through a macro or VB code, you can use the Set
Warnings action (method) to turn them off. Be sure to turn them back on
immediately after the command is issued, because they'll stay off until you
do (or until you close the database and open it again.)

On warning, though. No code will allow you to enter records if there is a
key violation. Setting the warning off will just let the query continue
without appending the offending records.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L