I have a DB that other units are using. Part of the db includes an 'archive' function in which old records are appended to an archive db and then deleted from the running db. Since the other units will have various file locations for their DBs, I started searching on how to fix it and came across this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=91128&highlight=append+query+vba

This db uses VBA to set the DestinationDB criteria for an append query.

Thanks to many on this board, and specifically WayneRyan, for help on the code to get this running.

http://www.access-programmers.co.uk/forums/showthread.php?t=106480

http://www.access-programmers.co.uk/forums/showthread.php?t=106595


--------------------


Key words: Append query, Delete query, VBA, SQL, DestinationDB, set properties