What is the difference between linking to a sql server using the ODBC Database link and the From Sql Server link? And which one is preferred if there is a better way?
Thanks
Expert
Windows 7 64bit 
Access 2010 32bit
What is the difference between linking to a sql server using the ODBC Database link and the From Sql Server link? And which one is preferred if there is a better way?
Thanks
VIP
Windows 11 Office 365
Nothing as far as I can tell.
They both end up using an ODBC Driver DSN to create the link.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Do I need to setup an ODBC connection in the windows ODBC Data Sources to use ODBC in access?
Posting Permissions
Reply With Quote