Can I "Append" and "Update" in one operation?

[Robin Chapple]

I have a database on my domain server. Additions and updates are
collected as a CSV file.

I need to append the new entries to a desktop and also update the
existing records on the desktop.

Thanks,

Robin Chapple

 

[Rick Brandt]

I have a database on my domain server. Additions and updates are
collected as a CSV file.

I need to append the new entries to a desktop and also update the
existing records on the desktop.

If you build an UPDATE query that updates Table1 with all of the fields from
Table2 and use an Outer Join (All records from Table2 and matching from
Table1) then records that exist only in Table2 will be appended to Table1
while all records that exist in both will be updated in Table1.

 

[Tom Lake]

I have a database on my domain server. Additions and updates are
collected as a CSV file.

I need to append the new entries to a desktop and also update the
existing records on the desktop.

Yes. Create an Update query and it will automatically append new records
in Access SQL, unlike SQL Server and ANSI SQL.

Tom Lake

 

[Joan Wild]

http://support.microsoft.com/kb/127977/en-us
http://support.microsoft.com/kb/208870/en-us

 

[Robin Chapple]

Thanks for that.

I see one problem:

"" NOTE: An update query can append and update records only if the
tables contain a unique index that does not have the AutoNumber data
type (or Counter data type in version 2.0). ""

Can I change the autonumber field on the desktop machine to a normal
number field to accommodate this?

The auto nimbler field will remain on the remote server.

Thanks,

Robin Chapple

 

[Joan Wild]

I would think so, yes. (you could have backed up your mdb, and tested it
out)