Results 1 to 4 of 4
  1. #1
    SteveApa is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    84

    Reserved Error (-7713); there is no message for this error

    Hi All.
    I have a access FE with SQL Server backend. I get this reserved error -7713 when I am doing nothing. SQL Server data is loaded to a subform... then just sitting there the error pops up. When I hit Ok for the error message box, all values in all columns of the the bound subform go to #Name? I have a cmdbtn that requeries the and all data shows again.

    Any ideas? Also, How can I trap this error?

    Thanks
    Steve
    Harrisburg, PA

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Sounds like you are losing connection to the backend.
    Are you on a wireless connection on a laptop? That will sometimes "go to sleep" and cause a loss of connection.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    SteveApa is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2015
    Posts
    84
    Yea, that is what I think too. No, I am hard wired, and thru vpn. But, how can I trap it so I can vb refresh query (vb refresh query does reconnect and return results)? Or is there a method to "Ping" the server... Maybe I should put in the "Form Open" a 2 minute "Ping" routine? What ping routine? Just a simple query that returns no results? OR maybe set the timeout to a higher value
    Here is my connection code...I use a global variable for the connection. When called, if it is the 1st call, the connection will be created, every call after that, it checks to see if the connection is open. If not open, it reconnects. I run this before every sql server call. My problem is that it "Errors" after the connection is made and the results are returned - timing of error seems variable.
    Code:
    Public Sub Check_Set_Sql_Server_Connection()
        If SQL_SERVER_ADODB_CN Is Nothing Then
            Set SQL_SERVER_ADODB_CN = New ADODB.Connection
        End If
        If SQL_SERVER_ADODB_CN.State <> adStateOpen Then
            SQL_SERVER_ADODB_CN.Provider = "sqloledb.1" ' Original connect string
            SQL_SERVER_ADODB_CN.Properties("Data Source").Value = "XXXXXXXX" ' production integrated security production
            SQL_SERVER_ADODB_CN.Properties("Initial Catalog").Value = "XXX" ' integrated security
            SQL_SERVER_ADODB_CN.Properties("Integrated Security").Value = "SSPI" ' integrated security
            SQL_SERVER_ADODB_CN.Open
        End If
    End Sub
    I just checked... in the code above, I never set the commandtimeout. I checked default and it is 30sec. I think I will change it to 120 (random guess) and have a background query run on the form open event at 100 sec. Does commandtimeout = 0 keep it from closing?

    Thanks

  4. #4
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Have a google about "Access opening a persistent connection".
    Start here https://www.access-programmers.co.uk...1/post-1813538

    You will find that a VPN connected backend may well be very slow, it is not ideal.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Replies: 6
    Last Post: 02-08-2023, 05:22 AM
  2. Replies: 1
    Last Post: 07-26-2016, 06:34 AM
  3. Replies: 3
    Last Post: 05-15-2014, 09:59 AM
  4. Reserved Error (|)
    By RGRAVLIN_BOS in forum Access
    Replies: 4
    Last Post: 06-14-2012, 07:09 AM
  5. Error 3464 Reserved Error
    By e.badin in forum Reports
    Replies: 6
    Last Post: 07-18-2011, 02:47 PM

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