I have an access front end that references a SQL backend. I have the
ODBC connection connecting the front end to the back end set up on my pc and it works fine.
My problem occurs when I distribute the front end to another user with out the ODBC connection
set up on their PC. They recieve an error. I have to distribute to a number of users but I do
not want them to set up the ODBC connection since that task is error prone and the users and not
all savy with computers.
how can I use VBA to set up the connection? Please use examples in your code.