Results 1 to 2 of 2
  1. #1
    Lams is offline Novice
    Windows 10 Access 2007
    Join Date
    May 2016
    Posts
    1

    MSAcess 2007 linked table SQLServer(2014) is very very slow

    Access: 2007
    SQL Server: 2014
    OS: Windows 10

    Currently my linked table connection string like this:
    Code:
    ODBC;DRIVER=ODBC Driver 11 for SQL Server;SERVER=HOSTNAME;APP=2007 Microsoft Office system;DATABASE=MyBE;ConnectRetryCount=3;TABLE=dbo.Audits
    My app works fine but I have to input SQL server user name and password every time when I start my Access App.

    So I change my linked table connection string like follow:
    Code:
    ODBC;DRIVER=SQL Server;SERVER=HOSTNAME;DATABASE=MyBE;UID=user;PWD=Password;TABLE=dbo.Audits;
    But after I RefreshLink and restart my Access app. Access took ages for 'Checking attached tables' and everything become very very slow.

    Do I miss some configuration in my connection string or Access itself?

    Any suggestion?

    Cheers,

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Are you using the 32bit or 64bit ODBC Driver? I would try making a small test catalog first with no tables. You may also try setting different cursor positions, I think theres an option to not start the database when you connect in the ODBC Configuration. Access 2007 and ODBC dont play nice. I have it in use for a number of databases, the error messages are the worst. they usually dont mean jack compared to whats going on.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 03-23-2016, 07:26 PM
  2. Insert INTO MS SQL Linked table too slow
    By green78 in forum SQL Server
    Replies: 5
    Last Post: 05-28-2015, 09:33 AM
  3. Slow INSERT on a Linked SQL Table
    By altemir in forum SQL Server
    Replies: 5
    Last Post: 07-22-2013, 04:57 PM
  4. Replies: 2
    Last Post: 03-29-2012, 07:45 AM
  5. Slow linked table
    By Okidoo in forum Programming
    Replies: 0
    Last Post: 05-19-2011, 03:02 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums