R
Robert
Using Access 2000 on Win XP Home.
I am getting a strange error as follows:
Error Number: -2147024769
Text: Method 'Connection of
object '_CurrentProject' failed.
If I set a breakpoint and step through the problem
area the error number reads the same,
but the text says "Automation error The specified
procedure could not be found."
The database has been in use for some time. I first
suspected a problem with references, but they all
seem to be in order, and nothing shows 'missing'.
I recently downloaded XP Service Pack 2 and had real
problems with my computer because of it...kept doing
an endless reboot at startup. What I've read so far
mentions problems like these with AMD processors,
but not with Intel processors like mine. Anyway, I
did a repair of XP from the install CD and that got
me up and running again; but I've had the problem
mentioned above ever since.
Here is the code
Dim cnn As Connection
Dim rsConstants As ADODB.Recordset
Dim SQLString As String
Set cnn = CurrentProject.Connection'-Error triggered
Set rsConstants = New ADODB.Recordset
I have tried an uninstall/reinstall of Office 2000 and
that doesn't help. I have tried several other databases
that utilize ADO and get the same error every time. I
have tried the database on another PC running Win ME and
it works fine. XP SP2 must have changed something on my
PC that the repair didn't change back. Hope someone out
there can help.
Thanks.
Robert
I am getting a strange error as follows:
Error Number: -2147024769
Text: Method 'Connection of
object '_CurrentProject' failed.
If I set a breakpoint and step through the problem
area the error number reads the same,
but the text says "Automation error The specified
procedure could not be found."
The database has been in use for some time. I first
suspected a problem with references, but they all
seem to be in order, and nothing shows 'missing'.
I recently downloaded XP Service Pack 2 and had real
problems with my computer because of it...kept doing
an endless reboot at startup. What I've read so far
mentions problems like these with AMD processors,
but not with Intel processors like mine. Anyway, I
did a repair of XP from the install CD and that got
me up and running again; but I've had the problem
mentioned above ever since.
Here is the code
Dim cnn As Connection
Dim rsConstants As ADODB.Recordset
Dim SQLString As String
Set cnn = CurrentProject.Connection'-Error triggered
Set rsConstants = New ADODB.Recordset
I have tried an uninstall/reinstall of Office 2000 and
that doesn't help. I have tried several other databases
that utilize ADO and get the same error every time. I
have tried the database on another PC running Win ME and
it works fine. XP SP2 must have changed something on my
PC that the repair didn't change back. Hope someone out
there can help.
Thanks.
Robert