I suggest you ...

Bug: (-7713) Reserved Error

Happing a lot in Office build 1611 for no apparent reason, completely stable in build 1609

17 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Mark JaskulaMark Jaskula shared this idea  ·   ·  Admin →
    Under Review  ·  Access TeamAdminAccess Team (Admin, Microsoft) responded  · 

    We are looking into this issue but may need more information from supporters.
    Please reply with a comment to indicate that it is okay for us to contact you directly regarding this issue.

    Thanks,
    Michal [MSFT]

    20 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Mark JaskulaMark Jaskula commented  · 

        @BigFoppa Unfortunately we're on Office 365, but thanks for trying.

        @Craig Atkins, our setup is also now Access 2016. We used to be on Access 2007 32bit and that was stable, then we went to Office 365 and Access 2016 64bit (perhaps it might have something to do with 64 versus 32bit?), for a while it was fine and stable until this.

      • Craig AtkinsCraig Atkins commented  · 

        Hi, we have this issue with a client. Running the DB in Access 2013 is perfect. Running it in Access 2016 throws these errors all over the place. Feel free to contact me directly as we can arrange a time for remote access to the system to demo.

      • BigFoppaBigFoppa commented  · 

        @Mark Jaskula, have you tried to uninstall the Windows Update KB3115501. Did that help you? It did the trick for us, no more ODBC errors.

        But if you're on Office 365 then this is not possible for you.

      • Mark JaskulaMark Jaskula commented  · 

        I noticed a sharp increase in the instability of MS Access in the last week or two, not sure if it's related to this error specifically, but general ODBC errors again (unable to insert record in table x...) that fail to add or edit simple records (using ODBC 13.1 connector to a fully patched MS SQL 2016 server on a fully patched MS Server 2016 from from fully patched Windows 10 clients). I have at least two areas affected (one of them on adding a simple contact). This was working fine previously and their have been no code updates, and the workarounds (which I'm still working on) seemingly have no rhyme or reason to them, like simply rearranging the code can fix the problem, or removing a sub-form which is totally unrelated fixed an issue in another instance.

        This is now becoming a massive bug bear to deal with, and I'm offloading more and more processing to a backend .Net project I'm integrated into the MS SQL Server as a means out of this. MS Access is fast going backwards in stability in the last few months for me, and it's been a big time waster. Please review and fix these issues asap, for many of us, this is our CRM, and a CRM that doesn't work is a recipe for your boss to come banging loudly on your office door.

      • JTJT commented  · 

        For whatever reason I am having trouble posting a comment here.

        Uninstalling the update referenced below fixed the issue for me. Office 2016 on Windows 7 Pro.

        I am now able to establish multiple odbc connections (pass-through queries) to the same database simultaneously, as I was able to do so before the update came around.

      • ArturoArturo commented  · 

        In my opinion it is sort of a Time-out, I just decreased ODBC refresh interval and increased ole/dde time out but I don't know if it will work.

      • Mark JaskulaMark Jaskula commented  · 

        You may contact me regarding this error. It still occurs but I've learnt to mitigate it.

      • BigFoppaBigFoppa commented  · 

        SOLVED, well at least I got it to work. But MS still has some figuring out to do...

        My solution: Uninstall the update for Office 2016 with number KB3115501.
        And stop Windows Update from updating Microsoft products. At least until MS states they got this under control.

        If your using Office 365 then this is of no help for you.

        //Big

      • Tom BurnsTom Burns commented  · 

        Michael

        Has there been any progress on this issue?

        Thanks

      • Anonymous commented  · 

        We have an Access 2016 front end that users are running on a mix of Windows 7 and 10. In early April we re-configured the database to point at SQL tables instead of an Access back end. Everything was fine for a couple of weeks. Now users are getting this -7713 error.

      • Anonymous commented  · 

        I configured my ODBC (5.1) connection to use in my Access 2016 front-end (Windows 10) with the following flags:
        1. Return matched rows instead of affected rows
        2. Allow big results sets
        3. Enable automatic reconnect
        4. Don't cache results of forward-only cursors
        5. Force use of forward-only cursors

        I am convinced that (-7713) reserved error has something to do with the flags set in the ODBC connection.

        I wish somebody can point me to a good article that can explain to me what flags to use in my ODBC connection to have an optimum connection to my Access 2016 front-end when I append big tables in Access to linked tables in MySQL

      • Anonymous commented  · 

        Anonymous is WvdMerwe. I enter before filling in my name.

      • Anonymous commented  · 

        I get this (-7713) Reserved Error out of the blue (Using Windows 10 and Access 2016) when opening a MySQL linked table in Access that have data in it. With no data in the table, I can open the table in Access without the error. I used the ODBC 5.1.6 driver and tried to relink with an ODBC 5.3 driver, but get the same error

      • Chris MumfordChris Mumford commented  · 

        A few days ago I linked an Access application to two SQLite tables. After doing so, I have experienced multiple crashes of application and/or received the '-7713' error.

        You may contact me.

        Office 365 MS Access 2016 MSO (16.0.7830.1018) 32-bit.

      • wilowilo commented  · 

        you can contact me fot this issue

      • BigFoppaBigFoppa commented  · 

        You can contact me after the weekend.

      • BigFoppaBigFoppa commented  · 

        I only get this error in Access 2016 installed from Office 365.
        Not using a standalone install.

      • Mark JaskulaMark Jaskula commented  · 

        I'm still getting the error and my observation is that it is ODBC related, and the issue probably started when we upgraded from MSSQL 2008 to MSSQL 2016 or as in my original post going from 1609 to 1611, both occurred around the same time. Most queries were constructed using DAO.QueryDef by default, but now I've switched where ever I can back to standard Access Recordsets and it's a lot better.

      • BigFoppaBigFoppa commented  · 

        Any news on this?

        I am having this problem with an old database that the client wants to move to Access 2016.
        My setup is Win 10, Access 2016 (O365), Sql Server thru ODBC.

      Feedback and Knowledge Base