Using udl in the connection for a linked table in Access from sql server -
07-29-2003
, 03:14 PM
I have an Access 2000 application that uses sql server as back end.
We're trying to avoid using ODBC to set up linked tables in access. Is
udl an alternative way? I set up the udl file but don't know how to
use them for linked tables in Access? This is what I have in my udl
file.
----
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=mySQLDatabase;Data Source=myServer01
----
Thanks |