Connect to SQL server through code?

Hi!
I have an Access db that I need to link to a SQL Server table. I'd like to
do that through code, does anyknow how to do that?
(I'd like it run from several clients and I don't want do create a
ODBC-connection on every client.)
Thx!
/eYou'd want to post this in an Access newsgroup. Or check
this Access FAQ - it has sample code for linking tables:
http://www.mvps.org/access/tables/index.html
-Sue
On Tue, 22 May 2007 21:45:08 +0200, "eric"
<eric@.hotmail.com> wrote:

>Hi!
>I have an Access db that I need to link to a SQL Server table. I'd like to
>do that through code, does anyknow how to do that?
>(I'd like it run from several clients and I don't want do create a
>ODBC-connection on every client.)
>Thx!
>/e
>