Access ODBC Linked Tables

  • Thread starter Thread starter Dave Ruhl
  • Start date Start date
D

Dave Ruhl

I apologize if this isn't the right place to ask this,
but I'm looking for a way to copy an SQL/Server ODBC
connection from one PC to another (actually, many
others).

I have an Access application which will be used on many
laptops throughout the company. The users will be able
to enter their data anytime, any place, and then upload
the data to an SQL Server database the next time they
connect to the network. (the laptop database has both
linked and local tables).

My problem is that I don't want to have to setup the ODBC
connection on each laptop. I'm hoping to find an easier
solution. I tried copying the ODBC.INI file but that
didn't seem to work. That seems to be the only file that
is updated when I create a new connection, so I was
hoping that was all I needed. Is this possible ? Or do I
have to go through the ODBC setup on each PC ?
 
A very common question that development shops ask VB or ms-access
developers:

How do you create a dsn-less connection?

(it is one that I also ask!)

However, while the above would be for a ADO recordset, you can also set this
up at the application level. That is not a question I ask...but a good
solution can be found here:

http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

And here is some more reading:

ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Art
icle=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
 
Thanks very much Albert, I think I found information on
these sites that will help me do what I want. Thanks
again !
 
Back
Top