Switchboard fails on startup

[Guest]

I upgraded from Access 2000 to Office Pro 2003. When I create a switchboard
it works until I close the application; thereafter I get the VB editor with
the error "Compile Error: Error in Loading DLL". When I click "OK", the VB
editor shows line "Set con = Application.CurrentProject.Connection" with the
word "Connection" is highlighted. I have deleted the swithboard form and
table and used the manager to recreate them, but the problem repeats.

 

[Jeff Conrad]

in message:

I upgraded from Access 2000 to Office Pro 2003. When I create a switchboard
it works until I close the application; thereafter I get the VB editor with
the error "Compile Error: Error in Loading DLL". When I click "OK", the VB
editor shows line "Set con = Application.CurrentProject.Connection" with the
word "Connection" is highlighted. I have deleted the switchboard form and
table and used the manager to recreate them, but the problem repeats.

Sounds like maybe a References issue. Access 2003 will by default set a reference
to both the DAO and ADO object libraries (something no other version has
done in the past). The SBM code generated by the wizard (in 2003) uses ADO code
in the form. If you have upgraded this database it is possible you may not have
a Reference set to the ADO library.

Go to the References dialog box and make sure you have the following option checked:
Microsoft ActiveX Data Objects 2.5 Library
You can set the priority below the DAO library.

Compile the code and then test the form.
Problem fixed?

 

[Guest]

Thanks, Jeff. I don't have the 2.5 library. I have 2.0, 2.1, 2.6, 2.7, and
2.8. I tried each to no avail. Still no compile.

 

[Jeff Conrad]

in message:

Thanks, Jeff. I don't have the 2.5 library. I have 2.0, 2.1, 2.6, 2.7, and
2.8. I tried each to no avail. Still no compile.

Humm, not good.

Someone in the past had a somewhat similar problem and I think
updating the MDAC files to 2.8 helped resolved the issue. Give that a
try and see if that gets things going.

http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en

If not, there are other ways around it.

 

[Guest]

The MDAC 2.8 features are contained in my version of Windows (XP), so the
update doesn't load for me. What other ways?

 

[Guest]

Jeff,
Thanks for the help; you got me on the right path. Seems that when I
upgraded, I had my virus protection on and it did not allow some dlls to
load. Specifically, MSDAO15 and DAO360. I loaded those and the problem
disappeared.
Thanks again.

Tem