Visual Basic Error

message from =?Utf-8?B?R2VvZmZU?= on 3 Jun 2004
i am using office professional 2003 on a xp professional operating system. When I open my main database in access 2003 I now get the following error message in visual basic debugger = "set dbs=CurrentDb()"
Compile error - Error in loading dll. The above relates to the switchboard form.

If I try to load the swithboard manager I get the message ActivX component cant create object.

The Northwind sample database opens OK!

Anyone got any ideas?

Thanks in anticipation.

Geoff
 
Pieter Wijnen replied to =?Utf-8?B?R2VvZmZU?= on 3 Jun 2004
Yupp
You Don't Have a Reference to DAO
Open a Module -> Tools/References -> Microsoft DAO 3.6
You Should also change every declaration of Recordsets to DAO.Recordset or
remove the reference to ADO

HTH

Pieter

"GeoffT" <anonymous@discussions.microsoft.com> wrote in message
news:B1813C09-9C10-40CC-B0F9-54E91662AC12@microsoft.com...
When I open my main database in access 2003 I now get the following error
message in visual basic debugger = "set dbs=CurrentDb()"
switchboard form.
cant create object.
 

Archived message: Visual Basic Error (Microsoft Access Error Message)