Results 1 to 4 of 4
  1. #1
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,065

    Connection Error

    Click image for larger version. 

Name:	SQLServererror.jpg 
Views:	11 
Size:	56.9 KB 
ID:	19616

    I get this error after a short time in Access with LInked SQL Server tables. I shut Access down and restart everythings fine for about 20-30 minutes then it starts all over again.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    It sounds to me like something on the SQL Server is closing the connection after a certain amount of time. Might want to check with your SQL DBAs to seem if there is some security setting/policy doing that.

  3. #3
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    The first thing I would check is whether or not you have a continuous connection to the server, even short interruptions of a few seconds can force access to croak.

    However, this message looks more like your server is terminating the connection, as in your server administrators only allow continuous connections of a certain period before timing out. If the tables are related to 3rd party software they may also have some internal controls that are enacted after continuous connection times are exceeded.

  4. #4
    accedeholdings is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Sep 2014
    Location
    Hackney, South Australia
    Posts
    17
    I am having the same problem with connection problem with SQL. I found out that there's something wrong with my DBA connector and now its smooth as ever.

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

Similar Threads

  1. Replies: 2
    Last Post: 01-21-2015, 06:03 AM
  2. ARITHABORT error on ODBC Connection
    By nyneave in forum SQL Server
    Replies: 0
    Last Post: 08-01-2012, 09:53 AM
  3. ODBC 32 to 64 Bit connection error
    By mgmtexecit in forum Reports
    Replies: 0
    Last Post: 03-30-2011, 10:06 AM
  4. ODBC 32 to 64 Bit connection error
    By mgmtexecit in forum Access
    Replies: 1
    Last Post: 03-30-2011, 10:05 AM
  5. Database Connection Error
    By pgabell in forum Access
    Replies: 1
    Last Post: 01-17-2009, 07:24 AM

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