• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

SQL Driver for MS Access (1 Viewer)

pekajo

Registered User.
Local time
Tomorrow, 02:12
Joined
Jul 25, 2011
Messages
57
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, 09:12
Joined
Mar 14, 2017
Messages
1,460
I have usually just picked the one that says "SQL Server". Others may chime in with more advanced expertise
 
Local time
Today, 09:12
Joined
May 22, 2010
Messages
2,280
SQL Server Native Client xx.x is the one we normally use.
 

Tera

Registered User.
Local time
Tomorrow, 01:12
Joined
Feb 2, 2019
Messages
1,143
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, 17:12
Joined
Jan 14, 2017
Messages
13,596
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, 09:12
Joined
May 22, 2010
Messages
2,280
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, 12:12
Joined
Feb 19, 2002
Messages
29,158
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, 17:12
Joined
Jan 14, 2017
Messages
13,596
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