Saving the DSN connection with a pass through connection Access 2007
I'm creating pass through connections in Access 2007 to MS SQL 2005. When I run one I have to select the DSN etc before it will run. I saw an example on the web with an older version of Access that allowed you to enter a connection string into the properties of the object so these prompts don't appear. Can I do something similar in Access 2007.