Error: "ODBC Call Failed", "Couldn't Execute Query; Couldn't Find Linked Table" When Opening A Table In MS-Access With ODBC (Doc ID 891609.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P3 Project Planner - Version: 3.1 and later   [Release: 3.0 and later ]
All Platforms

Symptoms

The following errors occur when opening a table in MS-Access with ODBC:
"ODBC Call Failed", "Couldn't execute query; couldn't find linked table"

After choosing "Select All", on the Link Tables window and choosing OK, the linking operation runs until a "Couldn't execute query; couldn't find linked table" error appears.

When this error comes up, look at the Link Tables window. In the background it will list a XXXXSRT file in the dialog box. This error means Access couldn't find the table XXXXSRT. The XXXXSRT table is a temporary file that holds data from report selections filters. Disregard this error and click OK.

After doing so another error message comes up, "[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine] The MicroKernel cannot find the specified file. (#12)". Click OK to see a listing of all of the tables for that project.

Double-click on the XXXXACT table you will see the table along with an "ODBC- -call failed" error. After clicking OK, the table comes up but all of the data fields will contain "#Name?" This error is independent of the operating system and the version of Access. 

When opening a table in Access, all of the data fields contain "#Name?"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms