Ubik
09-05-2006, 04:27 PM
I have a SharePoint list that I have linked to in Access. The Access file is on another webserver, and I am trying to use ASP to select records from the table that is linked.
I have a table named 'LinkedFromSP' and in that table is an ID field. The SQL I am using is:
"select ID from LinkedFromSP;"
I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find installable ISAM.
/selectanything.asp, line 21
I am able to successfully SELECT records from OTHER TABLES IN THE SAME db that are not linked to SharePoint.
I have upgraded MDAC and JET, on the server, as some other websites have suggested.
If this is a permissions issue, how do I pass LDAP credentials to Access - is this done in the connection string? (SharePoint installation we are using is using LDAP/Exchange, and I know nothing about how any of the credentials are set up.)
Any clue?
Oh, I forgot to mention that I can open the access db from a remote location and run the select query, and it runs just fine.
I have a table named 'LinkedFromSP' and in that table is an ID field. The SQL I am using is:
"select ID from LinkedFromSP;"
I am getting this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not find installable ISAM.
/selectanything.asp, line 21
I am able to successfully SELECT records from OTHER TABLES IN THE SAME db that are not linked to SharePoint.
I have upgraded MDAC and JET, on the server, as some other websites have suggested.
If this is a permissions issue, how do I pass LDAP credentials to Access - is this done in the connection string? (SharePoint installation we are using is using LDAP/Exchange, and I know nothing about how any of the credentials are set up.)
Any clue?
Oh, I forgot to mention that I can open the access db from a remote location and run the select query, and it runs just fine.