RDLFC
asked on
Create ODBC via VBA for access
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks guys for your input, but I used the article at the site below and found it to be very helpful.
http://support.microsoft.com/kb/892490
http://support.microsoft.com/kb/892490
ASKER
The comments assisted me in gathering an understanding but the article assisted in implementing the DNS less connection.
ASKER