ODBC issue using Microsoft Access

Jump to solution
willissr
Community Novice

We have configured an ODBC connection per the information we found elsewhere.  Testing it while configuring indicates it was successful.  We can use it with no problems to retrieve information into Excel.  However, when trying to link to the same tables using Microsoft Access, we get the message: Reserved error (-7733).  Has anybody successfully configured ODBC for using Microsoft Access 2013 64 bit?

1 Solution
biray
Instructure Alumni
Instructure Alumni

It appears there is a work-around using a passthrough query: https://support.microsoft.com/en-us/kb/303968

Check out the post on Microsoft Access forum board for more information: http://www.utteraccess.com/forum/index.php?showtopic=2032855

There may be an issue with how the Microsoft database engine "Jet" is processing the requests to retrieve the data. For further insight, please feel free to put in a ticket to support@instructure.com to request further discovery from our end.

View solution in original post