DSN less connection

I used the Access 2010 upsize Wizard to put a table on our SQL Server (2008 r2)and still use the 2010 Access database for the frontend. It works fine on my computer because I setup a data source from the Control Panel.

I see lots of articles on the internet about connection strings but what I don't understand is where and how to put the string. I did try to put it in the autoexec macro which I converted to VB, but I still get ODBC connection failed.

I don't want to have to setup the data source on each computer separately.

Thanks.

Jane

0 answers