Really need help! ADO not working

[Russ via AccessMonster.com]

Operating System Windows XP Service pack 2
Using Access 2003
have the following references checked:
' Microsoft ADO Ext. 2.8 for DDL and Security
' Microsoft DAO Ext. 3.6 Object Library
' Microsoft ActiveX Data Objects 2.8 Library
Tried putting them in diffrent order, just can not make the error go away,
never used to get it. Something must have changed. Please help me figure out
why ado does not work anymore.
Error on this line.
Set cnn = CurrentProject.Connection

 

['69 Camaro]

Hi, Russ.

Please help me figure out
why ado does not work anymore.
Error on this line.
Set cnn = CurrentProject.Connection

I'm guessing the error message doesn't say, "Your sink is clogged. Call a
plumber." Perhaps the error message is too embarrassing to share it with us.
;-)

Have you installed new software lately? Updated old software? If so, have you
checked the MDAC version to ensure it wasn't overwritten with an older file?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[Russ via AccessMonster.com]

Error is;
Run time error
Class not registered

Have you installed new software lately? = (Access 2003 upgrade fromm 2000)
Have you checked the MDAC version to ensure it wasn't overwritten with an
older file? = How do you check MDAC version and what version should it be?

Hi, Russ.

Please help me figure out
why ado does not work anymore.
Error on this line.
Set cnn = CurrentProject.Connection

I'm guessing the error message doesn't say, "Your sink is clogged. Call a
plumber." Perhaps the error message is too embarrassing to share it with us.
;-)

Have you installed new software lately? Updated old software? If so, have you
checked the MDAC version to ensure it wasn't overwritten with an older file?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Operating System Windows XP Service pack 2
Using Access 2003

[quoted text clipped - 7 lines]

Error on this line.
Set cnn = CurrentProject.Connection

 

['69 Camaro]

Hi, Russ.

How do you check MDAC version and what version should it be?

Check the version with the MDAC Component Checker. It's available for download
from the following Web page:

http://www.microsoft.com/downloads/...F6-4A21-4B43-BF53-14332EF092C9&displaylang=en

You should have MDAC 2.8 SP-1.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Error is;
Run time error
Class not registered

Have you installed new software lately? = (Access 2003 upgrade fromm 2000)
Have you checked the MDAC version to ensure it wasn't overwritten with an
older file? = How do you check MDAC version and what version should it be?

Hi, Russ.

Please help me figure out
why ado does not work anymore.
Error on this line.
Set cnn = CurrentProject.Connection

I'm guessing the error message doesn't say, "Your sink is clogged. Call a
plumber." Perhaps the error message is too embarrassing to share it with us.
;-)

Have you installed new software lately? Updated old software? If so, have
you
checked the MDAC version to ensure it wasn't overwritten with an older file?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Operating System Windows XP Service pack 2
Using Access 2003

[quoted text clipped - 7 lines]

Error on this line.
Set cnn = CurrentProject.Connection

 

['69 Camaro]

Hi, Russ.

Also ensure you have Jet 4.0 SP-8 installed. (It comes with Access 2003, but if
other software was installed afterwards, this file could be overwritten.) For
instructions on how to tell your workstation's version, please see the following
Web page:

http://support.microsoft.com/kb/q239114/

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Hi, Russ.

How do you check MDAC version and what version should it be?

Check the version with the MDAC Component Checker. It's available for
download from the following Web page:

http://www.microsoft.com/downloads/...F6-4A21-4B43-BF53-14332EF092C9&displaylang=en

You should have MDAC 2.8 SP-1.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Error is;
Run time error
Class not registered

Have you installed new software lately? = (Access 2003 upgrade fromm 2000)
Have you checked the MDAC version to ensure it wasn't overwritten with an
older file? = How do you check MDAC version and what version should it be?

Hi, Russ.

Please help me figure out
why ado does not work anymore.
Error on this line.
Set cnn = CurrentProject.Connection

I'm guessing the error message doesn't say, "Your sink is clogged. Call a
plumber." Perhaps the error message is too embarrassing to share it with us.
;-)

Have you installed new software lately? Updated old software? If so, have
you
checked the MDAC version to ensure it wasn't overwritten with an older file?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Operating System Windows XP Service pack 2
Using Access 2003
[quoted text clipped - 7 lines]
Error on this line.
Set cnn = CurrentProject.Connection

 

[Russ via AccessMonster.com]

Thanks for the help, this is what I found;
I currently have...

4.0.8618.0 Windows XP SP2 and Security Bulletin MS04-014
&
MDAC 2.8 SP-1. on windows xp sp2

Russ

Hi, Russ.

How do you check MDAC version and what version should it be?

Check the version with the MDAC Component Checker. It's available for download
from the following Web page:

http://www.microsoft.com/downloads/...F6-4A21-4B43-BF53-14332EF092C9&displaylang=en

You should have MDAC 2.8 SP-1.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

Error is;
Run time error

[quoted text clipped - 31 lines]

 

[Russ via AccessMonster.com]

still looking for help.

Thanks for the help, this is what I found;
I currently have...

4.0.8618.0 Windows XP SP2 and Security Bulletin MS04-014
&
MDAC 2.8 SP-1. on windows xp sp2

Russ

Hi, Russ.

[quoted text clipped - 19 lines]

 

[Russ via AccessMonster.com]

Still looking for help.

Thanks for the help, this is what I found;
I currently have...

4.0.8618.0 Windows XP SP2 and Security Bulletin MS04-014
&
MDAC 2.8 SP-1. on windows xp sp2

Russ

Hi, Russ.

[quoted text clipped - 19 lines]

 

[Tim Ferguson]

Russ wrote:

Still looking for help.

You may know that visitors to these newsgroups are all volunteers, chipping
in in their free time, offering help or advice when they feel they can. If
nobody knows the answer to your problem, then I'm afraid that's all there
is to it. As I am sure you did, I tried looking for answers on Google and
all the responses that I saw referred to MDAC installation problems.

I am sure that you are also looking in MSDN and the knowledge base... paid
support lines from MS would seem to be the final solution.

Best of luck.


Tim F

 

[RoyVidar]

You may know that visitors to these newsgroups are all volunteers,
chipping in in their free time, offering help or advice when they
feel they can. If nobody knows the answer to your problem, then I'm
afraid that's all there is to it. As I am sure you did, I tried
looking for answers on Google and all the responses that I saw
referred to MDAC installation problems.

I am sure that you are also looking in MSDN and the knowledge base...
paid support lines from MS would seem to be the final solution.

Best of luck.


Tim F

Well, there's this one, but this is perhaps a bit special, even if
it also details MDAC challenges? Anyway, it's quite a bit down
(post 18) - watch for linebreak in the link

http://groups.google.com/group/micr...lesdaovba/browse_frm/thread/2556792ea4d624f5/

Here's another thread with suggestions on similar challenge (though not
successfull, but perhaps it can give an idea or two to try?)
http://groups.google.com/group/micr...lesdaovba/browse_frm/thread/c98d794bb3595943/

 

[Russ via AccessMonster.com]

Tim,
Believe me I appreciate all the volunteers here; they have always helped me
tremendously.
But, I do not know of a way to see if my post are even being read, so I do
not know if the question can not be answered or if was just moved down the
list and lost.
Hope I did not offend anyone.
Russ

 

[Tim Ferguson]

But, I do not know of a way to see if my post are even being read, so
I do not know if the question can not be answered or if was just moved
down the list and lost.
Hope I did not offend anyone.

No offence taken: but it sometimes appear that people are disappointed here
because they have unrealistic expectations of the support that they may get
on the newsgroups.

Best of luck with your problem


Tim F