I am using the Connect String option of the Connection Designer to establish a link to an Access table from a remote view. How can I setup global variables to pass to the Connect String? Simply, defining public variables does not work.

Thanks for the help.

Lance