Anyway to Automatically Append Records?

[schulzy175]

I am wanting to append records from a very large linked-table to adjust for performance so I can pull the most recent records from the appended table. But in order for this to work fluidly, I am wanting to automate the records being appended to the appropriate table. Is there anyway to do this with or without code?

[pbaldy]

Sure, create an append query that adds the appropriate records, and execute it from vba or a macro.

[CJ_London]

your linked table and your local table need to have one or more fields you can use to uniquely identify a record to see if you have already have that record in the local table. Then use a left join between the two tables to identify which ones have not been loaded. Something like

INSERT INTO localTable
SELECT linkedTable.* 
FROM linkedTable LEFT JOIN localTable on LinkedTable.uniqueIDfield=localTable.uniqueIDfield
WHERE localTable.uniqueIDfield IS NULL

[schulzy175]

Thanks for the reply. Thankfully this is what I was doing while waiting for a response so time wasn't wasted. I have come across an issue already though. I am trying to save the changes without the save changes dialog box, but I cannot find any functions in regards to "savechanges" other than

DoCmd.RunCommand acCmdSave

.

[pbaldy]

Save what changes? Executing a query shouldn't throw that kind of message. You haven't shown your code, so maybe this is relevant:

http://www.baldyweb.com/SQLWarnings.htm