The develpers have the following error when using any NFG% tables. The code works in production but not in development. I do not know where to look to compare differences. I have checked constraints/code/structures/dependencies.
Any ideas where to look next?
#: -2147217911 (80040e09)
Automation error (Error 440)
When you accessAutomation objects, specific types of errors can occur. This error has the following cause and solution:
An error occurred while executing amethod or getting or setting aproperty of anobject variable. The error was reported by the application that created the object.
Check the properties of the Err object to determine the source and nature of the error. Also try using the On Error Resume Next statement immediately before the accessing statement, and then check for errors immediately following the accessing statement.
Code Statment that causes error:
Set rsDailyVol = New ADODB.Recordset
rsDailyVol.CursorLocation = adUseClient
rsDailyVol.Open "nfg_daily_wacc", cnnDB, adOpenDynamic, adLockOptimistic
It works fine for other tables, just not ones that start with NFG*. This app/db was dumped on IS after vendor went out of business.