Hi, I have migrated an access 97 backend to sql server 2005 database now need to link tables in access97
to the sql server backend. The access 97 database is on a network drive.
How can I create a dsn for the access db that's on a network drive?
Hi, I have migrated an access 97 backend to sql server 2005 database now need to link tables in access97
to the sql server backend. The access 97 database is on a network drive.
How can I create a dsn for the access db that's on a network drive?
I usually use ODBC. Here is a good write-up on how to do that: http://fontstuff.com/ebooks/free/fsL...oSQLServer.pdf
Thanks, that was what I was looking for.I usually use ODBC. Here is a good write-up on how to do that: http://fontstuff.com/ebooks/free/fsL...oSQLServer.pdf