Pass Through Query - Update

[accessNator]

I have 3 queries in Access 2007

tableA - same structure in local and remote database

1. Query1 (Query based on a table "A" in the LOCAL database)
2. Query2 (Query based on a table "A" on a REMOTE database using a pass through query set up)
3. Query3 (Query based on what records are different from Query1 and Query2)
Query3 returns a list of records in table "A" in the LOCAL database that either doesnt exist or have been modified is different in table "A" on the REMOTE database.

Query1:
Id,CompanyName, Code
5,ABC Company, 1
10,DEF Company, 2
15,GHI Company, 2
20,IJK Company, 1

Query2:
Id,CompanyName, Code
10,DEF Company, 2
15,GHI Company, 1

Query3:
Id,CompanyName, Code
5,ABC Company, 1
15,GHI Company, 2
20,IJK Company, 1

What I would like to do is loop the the Query3 recordset and update it accordingly on my remote table "A" database so both tables in my local and remote match.

I thought I can do this using a Pass Through Query and using an UPDATE setup, but I cant find a good example on how to do this? Can someone point me a direction for a sample setup?

Thanks.

 

[Galaxiom]

By default PassThrough queries are not updateable. You needd to add more commands to change that.

http://support.microsoft.com/kb/138094

 

[accessNator]

By default PassThrough queries are not updateable. You needd to add more commands to change that.

http://support.microsoft.com/kb/138094

Thanks for your reply but please forgive me since I am not totally familiar with the Pass Through Query setup....the link you provide is for a view? I just want to send a pass through update query, but need more sample code.

Thanks.