File vs Machine Data Source

C

Chuck B

Using VBA I am liking SQL Server tables to an Access 2000
mdb using; DoCmd.TransferDatabase
acLink, "ODBC", "ODBC;DSN=ACT;UID=ACT;PWD=;", acTable,
strTblName1, strTblName2, , True.
I can get it working with the above code when I set up a
System DSN.
The Application I am linking to recommeds that a File DSN
be created for ODBC connection to its tables. I haven't
been successful in linking the tables using the File DSN.
What is the difference between a file and system DSN? and
is File DSN the same thing as the Machine Data Source?

Thanks
Chuck
 
Top