Bug: (-7713) Reserved Error
Happing a lot in Office build 1611 for no apparent reason, completely stable in build 1609
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.
@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 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.
@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.
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.
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.
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.
You may contact me regarding this error. It still occurs but I've learnt to mitigate it.
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.
Tom Burns commented
Has there been any progress on this issue?
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.
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 is WvdMerwe. I enter before filling in my name.
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 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.
you can contact me fot this issue
You can contact me after the weekend.
I only get this error in Access 2016 installed from Office 365.
Not using a standalone install.
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.
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.
This exact error came up in the Access MVP email group - not resolution yet. The consensus is that it is related to something with ODBC .... just an fyi.