Okay, I created an append query that appended to an external database. In the append dialog, i browsed for the file name of the database to be appeneded to. Now Access uses the filename to set the DestConnectStr and the DestinationDb properties of this append query.
Now, my question is how do you access the DestConnectStr and the DestinationDb properties of the append query inside visual basic?
I tried the following:
first I created my append query named "Append_Test" that appended to another database table.
Then inside Visual Basic i typed the following:
' query is used to hold queryDef
Dim query As QueryDef
' gets the append query needed
Set query = CurrentDb.QueryDefs("Append_Test")
so now I have my querydef object set to my append query. How do I access and change the DestConnectStr and the DestinationDb properties of this query inside VB?