Append Query

A

Access Beginner

i have an append query that requeries a main database every 15 minutes and
pulls any new information through, however i constantly get an error stating
that x records couldnt be addeed due to ket violations, which is what i want,
however i do not wish to see the error message is there any way to disable
this???
 
J

Jeff Boyce

I have good news and bad news...<g>

Yes, it is possible to disable that warning.

Yes, it is possible to disable that warning.

I don't know how you are "requerying ... every 15 minutes" but I'm guessing
via a macro or via a procedure. Take a look at the SetWarnings command --
turning off the warnings means you won't see that warning ... and you won't
see ANY warnings, until you turn it back on.

Do you feel lucky? Well, do you?! (hint: ALWAYS turn warnings back on at
the end of your macro/procedure).


Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query 1
Wierd Append error 6
Append Query Fails, MS Access 2000 bug? 5
Append Query 5
Access 2002 Append Query Problems 1
How do I turn off the error (violations) messages in an append que 1
Append Query Problem 1
Append only new records with an append Query 1

Top