Missing connection class (ADO)

S

Sander

Hi,

I have a problem using the currentproject.connection.

Here's the start of the module

Dim cnn As ADODB.Connection
Dim cat As New ADOX.Catalog
Dim col As ADOX.Column

'Set connection and catalog to current database
Set cnn = CurrentProject.Connection
cat.ActiveConnection = cnn

When reachting the set cnn.. line it access 2000 returns a
error saying that the class is not registered. It used to
work, but I think that on some recent Windows 2000
autoupdate something was wrong.

Any ideas what to do.

Thanx
..
 

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