AccessConnection problem

[Eric]

I have an .mdb I'm trying to get to work on one of our employees in our CA
office. I PCAnywhered in and discovered the problem is that whenever the
code hits

set cnLocal = CurrentProject.AccessConnection I endup w/ the following
error.

Err.Number -2147467259
Err.Description = "Method 'AccessConnection' of object '_CurrentProject'
failed"

This code works fine on several other PCs, but not this one. Not sure if it
has something do w/ running Office XP Pro on a Win98 machine, but that may
have nothing to do w/ it.

Also, I updated all office and windows updates just to be sure and to no
effect.

Thanks,
Eric

 

[Randy Harris]

I have an .mdb I'm trying to get to work on one of our employees in our CA
office. I PCAnywhered in and discovered the problem is that whenever the
code hits

set cnLocal = CurrentProject.AccessConnection I endup w/ the following
error.

Err.Number -2147467259
Err.Description = "Method 'AccessConnection' of object '_CurrentProject'
failed"

This code works fine on several other PCs, but not this one. Not sure if it
has something do w/ running Office XP Pro on a Win98 machine, but that may
have nothing to do w/ it.

Also, I updated all office and windows updates just to be sure and to no
effect.

Thanks,
Eric

I don't have Office XP, perhaps things are different. With Access 2000,
AccessConnection is not a Property or Method of the CurrentProject object
(as suggested by the error message). You might want to try:

set cnLocal = CurrentProject.Connection

 

[Eric]

Well that didn't quite work.
It works fine on my machine and one or two others, but on the pc in question
I get a new error.

Err.Number = -2147221164
Err.Description = "Class not registered"

Any ideas/suggestions?

 

[Randy Harris]

Well that didn't quite work.
It works fine on my machine and one or two others, but on the pc in question
I get a new error.

Err.Number = -2147221164
Err.Description = "Class not registered"

Any ideas/suggestions?

Go to the code window, select Tools->References from the menu. Check to see
if any of the checked references are missing.

 

[Eric]

Already checked that.

Eric

Go to the code window, select Tools->References from the menu. Check to see
if any of the checked references are missing.

 

[Scott McDaniel]

Don't know if you've looked into this article:

http://support.microsoft.com/default.aspx?kbid=281784

Have you installed the latest Jet 4.0 service packs to the Win98 computer:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114&Product=acc#7

 

[Eric]

The Jetpack update did the trick.

Thanks for all the sugestions,
Eric Dreksler