Re: Prevent Duplicates using an Append Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Disregard the "you cant do this" message. It is SPAM (or worse), and has
been showing up all over the newsgroups.

Regards

Jeff Boyce
Microsoft Office/Access MVP

<pete.trudell@xxxxxxxxxxxxxxx> wrote in message
news:1158670802.767666.110750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Morning, we have 5 offices throughtout the state which use daily an
append query to update a Master Table in Austin. We need to find a way
to flag the records once they are appended to that table to prevent
appending them again later.

The query uses a date range to select records from the local table to
copy to the Master. Usually, we only select a days worth of records.

Thanks, Appreciate any suggestions.



.

Relevant Pages

  • Re: Appending Records
    ... Jeff Boyce ... Microsoft Office/Access MVP ... database 2 into database 1. ... I created an append query but I keep getting ...
    (microsoft.public.access.externaldata)
  • RE: Multi user database
    ... manner and push updates to the backend. ... the other user updates table c then run the append query. ... Right now I can determine when the master table is updated, ... the database they should 'share' the data not update to/from local copies. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Multi user database
    ... manner and push updates to the backend. ... the other user updates table c then run the append query. ... Right now I can determine when the master table is updated, ... the database they should 'share' the data not update to/from local copies. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Converting Query to VB
    ... therefore what the next number should be, I am using DMax(). ... past and seems to know his stuff,) that using DMAXin an append query is ... Jeff Boyce wrote: ... have added to a table, I'm not understanding why ...
    (microsoft.public.access.queries)
  • Re: Converting Query to VB
    ... Jeff Boyce wrote: ... I have been told by someone on this forum, that using DMAX() in an append query is problematic, as each record added will increase the note_id required for the next record to be added, but in an append query, the DMAXfunction will not reliably return the new higher number. ... If you can create a query that returns all the fields/values you wish to have added to a table, I'm not understanding why you cannot use an append query to append those records? ...
    (microsoft.public.access.queries)