Reserved error (-7732) when attempting to open Oracle table via Access
Posted on 2011-04-04
We are trying to open an Oracle table on a machine that is running Windows 7 64 bit, Office 2010 64 bit, and has the 64 bit Oracle client 100201 installed. In Excel we can go to Data, From Other Sources, From Microsoft Query/ODBC, Select the database, login with our credentials, and the data is imported. However, when attempting this from Access via External Data, ODBC, Import, Machine Data Source, "Reserved error (-7732); there is no message for this error" appears. Since the connection works via Excel, maybe there is a setting that needs changed in Access? We have installed the latest Office and Windows patches on this machine. Thanks.