SQL Driver for MS Access (1 Viewer)

pekajo

Registered User.
Local time
Today, 23:44
Joined
Jul 25, 2011
Messages
60
Hi,
Still trying to work out connecting ms access front end to sql back end. Seems I need to add an sql connection to my win10 pc. When I go there there are 3 options. (see attached)
Can you tell me which one is best to use or are they used for different applications?
Thanks
Peter
 

Attachments

Isaac

Well-known member
Local time
Today, 06:44
Joined
Mar 14, 2017
Messages
1,513
I have usually just picked the one that says "SQL Server". Others may chime in with more advanced expertise
 
Local time
Today, 06:44
Joined
May 22, 2010
Messages
2,313
SQL Server Native Client xx.x is the one we normally use.
 

Tera

Registered User.
Local time
Today, 22:44
Joined
Feb 2, 2019
Messages
1,176
SQL Server Native Client xx.x is the one we normally use.
From Microsoft if you don't know:

The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new development work. Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features.

 

isladogs

CID
Local time
Today, 14:44
Joined
Jan 14, 2017
Messages
13,616
I remember reading the article in Tera's link some time ago with its reference to the rather strange word 'undeprecated'

Using the latest driver makes sense if you are using the latest features in SQL Server.
However that will require specifically checking and, if necessary, installing it on each PC which has the FE concerned.

However for most purposes either of the two basic SQL Server drivers installed with Access will be sufficient for your needs
...and will be guaranteed to work on all machines running the full version of Access
 
Local time
Today, 06:44
Joined
May 22, 2010
Messages
2,313
After reading Tera's post I checked my ODBC config on my home laptop and the Native Client was not available. But at work it is very prevalent, and that was the ticket.

Thanks Colin.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:44
Joined
Feb 19, 2002
Messages
29,179
I have usually just picked the one that says "SQL Server". Others may chime in with more advanced expertise
This is the default driver that is loaded with Access. It is very old and is not comparable with newer data types in SQL Server so if you do not have control over the SQL Server table definitions, you might run into a problem if you use this driver. I would use the top one in the list which is a newer version. However, you will have to ensure that the driver you use is available for ALL of your users as well. If you have IT support, they can handle this for you if you ask them to.
 

isladogs

CID
Local time
Today, 14:44
Joined
Jan 14, 2017
Messages
13,616
Pat is making the same point as I did in post #7 but with the opposite emphasis.
To reiterate, if you are using or intend to use the latest SQL features/datatypes, you need the latest driver.
However if you have no intention of doing so, it is fine to use the very old basic SQL Server driver as it will do the job.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom