MS Access 2010 / MSSQL 2012 connection painfully slow

I took an old database of mine (Backend = MSSQL 2005 / Front End = MS Access 2003 MDB file), and transferred a Dell Inspiron laptop intended for demonstration purposes. The laptop is running MSSQL 2012 SP1 (the Business Intelligence version) and MS Access 2010. It works, but it is SLOW.
Form renders on the production version of the database (which runs on MSSQL 2008 standard with Access 2007 and 2010 clients) are close to instantaneous.
Here, on the Dell Inspiron, they take 5 to 10 seconds. Reports are similarly slow.
While the Dell Inspiron, aint exactly a screaming fast machine. I've seen this database run far faster on far slower & older machines.  CPU, memory, and I/O all looked reasonable when I was running the database.
The one new factor on this machine is Dell is MSSQL 2012 SP1. I'm inclined to think the slowness is associated with MSSQL 2012 either directly or indirectly.
Is running an old MSSQL 2005 database on a MSSQL 2012 server a problem?
Is it the ODBC connection between the Access file and the MSSQL 2012 server. Is MSSQL 2012 geared for OLE DB rather than ODBC?
Is Access 2010 struggling to connect an old 2003 MDB file with MSSQL 2012?
I ran out of the time with the machine and didn't check the SQL Server Error Log or the Windows Event Log. I should have.
I did a quick web search. I found some other folks with similar issues:
Who is Participating?
Armen Stein - Microsoft Access MVP since 2006Connect With a Mentor PresidentCommented:
I had the exact same experience using an older Access + SQL application, after I changed the back-end to SQL 2008 R2.  The problem was that merely opening a linked table took multiple seconds.  Changing the driver from:

{SQL Server}


{SQL Server Native Client 10.0}

made a huge difference, from intolerable to instantaneous.

You could also try {SQL Server Native Client 11.0}, which is even newer.

However, you need to make sure that the newer drivers are installed on the PCs that will be running your app.  The old {SQL Server} driver is always there.

Also, I discovered that I needed to enable TCP/IP connections for “SQL Server Network Configuration” in the SQL Server Configuration Manager.

Hope this helps,
Armen Stein
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
How are you connecting?  Which driver are you using?

jdanaAuthor Commented:
an ODBC driver
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:

an ODBC driver

Which one? Version, bits etc.
jdanaAuthor Commented:

Thanks for coming through! Great response.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.