ADO error after installing office 2003

B

Bruce

Hi. I have a database using written in ADO. But after
installing office2003 but retained the old version of
access as well. I am now getting an automation error for
all the ado codes. not even the connection strings.

e.g. set adocnn = currentproject.connection

i get a "method 'connection' of object '_currentproject'
failed"

please help.

I even tried running it on officeXP but still this error.
 
A

Arvin Meyer

Check your references.
It may be that the version of ADO you are using is different, or more likely
located in a different place.

From any code window, choose Tools ... References and follow the paths or
fix any that are marked missing.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top