P PaulSpell Registered User. Local time Today, 18:54 Joined Apr 19, 2002 Messages 201 Oct 15, 2003 #1 Can someone please tell me how to set the DestinationDB property of a query programatically?
P PaulSpell Registered User. Local time Today, 18:54 Joined Apr 19, 2002 Messages 201 Oct 16, 2003 #2 Ok thanks, I feared you would say that! I guess I will just have to re-create them all in code then. Alternatively is there a way of globally setting the destination path for a database?
Ok thanks, I feared you would say that! I guess I will just have to re-create them all in code then. Alternatively is there a way of globally setting the destination path for a database?
P PaulSpell Registered User. Local time Today, 18:54 Joined Apr 19, 2002 Messages 201 Oct 19, 2003 #3 The tables are all linked, but I have a couple of make table queries and need them to create the new table in the source database rather than the current one. I did what you suggested and it works fine. Thanks.
The tables are all linked, but I have a couple of make table queries and need them to create the new table in the source database rather than the current one. I did what you suggested and it works fine. Thanks.
