Looking for assistance on an issue in Excel (2000 sp2 / pro) and access 2003.
I have a database and in my VB code have created a ADODB.connection to it. It is called conn. I have used it for sqlPassThrough queries as follows:
Expand|Select|Wrap|Line Numbers
- modfindSQL = "SELECT ....."
- Set modfindrs = conn.Execute(modfindSQL, , dbSQLPassThrough)
Expand|Select|Wrap|Line Numbers
- Set rstProjects = conn.openRecordset("Projects", dbOpenDynaset, dbAppendOnly, dbopentable)
- With rstProjects
- .AddNew
- ![Project ID] = ProjectID
- .
- .
- .
- .Update
- End With
VB for all Applications
MS Excel 9.0 Object Library
OLE Automation
MS Forms 2.0 Object Library
MS Office 9.0 Object Library
MS ActiveX Data Objects 2.5 Library
I have tried enabling the following too:
MS ActiveX Data Objects Recordset 2.6 Library
MS ADO Ext 2.6 for DLL and Security
With no avail. The error I get is:
Runtime Error '3001':
Application-defined or object-defined Error
and i have also tried :
Expand|Select|Wrap|Line Numbers
- Set rstProjects = conn.Execute("Projects", , dbSQLPassThrough)
- Set rstProjects = conn.Execute("Projects", , dbConsistent)
- etc
Any help will be much appreciated..
Many thanks