Solved

Access 2010 SQL - Strange Connection Problem

Posted on 2011-03-12
3
615 Views
Last Modified: 2012-05-11
I up-sized a test Access 2010 db with three tables using Access and SQL Server Migration Assistant to a local SQL Server Express installation on my Win 7 64 bit system and to a hosted SQL Server 2008 db.   Both setups take 10 to 20 minutes to open a table of 462 rows.  The strange part is that I can open these same database from another 64bit win 7 computer on the network and they both open immediately without problem.  

Process to date:
1.  Ran the Microsoft online FixIt uninstall for Office 2003, 2007, and 2010.  Rebooted and reinstalled 2010 and tested both databases.  Same problem.
2. Removed all related ODBC 32 bit and 64 bit DSN entries and re-entered the 32 bit only.  No Change
3.  Removed fingerprint reader software and tested with no change ( MS Tech support reported that an HP Laptop had a similar problem caused by the fingerprint software)
4. Removed all other software that uses ODBC
5. Opened a case with a senior Microsoft tech support person for both SQL server and Access.   They have run a number of tests and have copies of the databases but have not found a solution after 3 weeks.  

The computer with the problem is a:
ASUS P5Q Premium MB
Intel Q6600 (not overclocked)
4 gb mem
2 WD 1tb drives in Raid 1 confg.
1 WD 2tb drive (non raid)

I have no other problems with this computer and Access database not linked to SQL run great. (including one with large tables over 500,000 rows.)

Currently the only solution appears to be a new workstation.    Any assistance would be greatly appreciated.


0
Comment
Question by:Jim2009
  • 2
3 Comments
 
LVL 28

Expert Comment

by:Ryan McCauley
ID: 35118243
There are no other speed problems on this computer? So the only combination that's slow appears to be when you open THIS SQL-linked Access database from THIS workstation? That's an odd combination, and as far as I'm aware, different workstations with Access on them should connect to these remote tables in the same way, so I'm not sure what could make this connection different.

Using one of the slow workstations, can you create a new table and populate it with 500 rows or so? That way, you can see if it's tied to the up-converted table, or if it's the Access connection to that server in general.
0
 

Accepted Solution

by:
Jim2009 earned 0 total points
ID: 35227300
Worked with MS Level 2 Tech and located the problem.  The ODBC SQL Trace was on.  Not sure how it got selected but everything work correctly as soon as it was turned off.   ryanmccauley, Thanks for your input.  
0
 

Author Closing Comment

by:Jim2009
ID: 35292491
Had to use MS Tech support.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CONVERT date time to a different time zone. 2 42
Cassandra Select Query 1 53
Square brackets 4 38
How to load 2 images in same column in Delphi 2 31
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now