append query inserting multiple times.

  • Thread starter dizzy access user
  • Start date
D

dizzy access user

simple database created with append query. On other PCs it will work fine,
with the inserted txt being entered on a table once. On my PC however it
first adds it once, the next time the query is used it adds the data twice,
third time 4 times and continues each time increasing to the power of 2. i
have reinstalled the application, upgraded and downloaded new updates but no
change. Is it an odbc, registry file issue or something else?
 
6

'69 Camaro

Hi.
On my PC however it
first adds it once, the next time the query is used it adds the data twice,
third time 4 times and continues each time increasing to the power of 2.
Click to expand...

Sounds like a sticky trigger finger. An append query will copy the source
data and insert it into the destination table. If there's no unique index on
the fields in the destination table to prevent duplicate entries, then
appending the data a second time will add the same records a second time, so
that there are two copies. Append the data a third time, and there are now
three copies.

Perhaps only one append is all you need?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Top