When I run an append query that deletes duplicates in a table, an error message comes up saying,"Microsoft Access can't append all the records in the append query." The error message is just telling me that some of the records will be deleted, which makes sense, seeing as I want it to delete all of the duplicates. I need to run this append query on a daily basis, and I am curious if there is any way I can keep this error message from coming up? I have a feeling it is something that cannot be fixed.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Disable error message with append query
- Thread starter Jennpen1
- Start date
run the query as part of a macro.
make the first line
docmd.setwarnings = No
query
docmd.setwarninngs = yes
you must set the warnigs back to yes or you'll get no warnigs at all in the db. Not good Eddie Griffiths
IS Support
Southland District Health Board
New Zealand
make the first line
docmd.setwarnings = No
query
docmd.setwarninngs = yes
you must set the warnigs back to yes or you'll get no warnigs at all in the db. Not good Eddie Griffiths
IS Support
Southland District Health Board
New Zealand
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question