Access doesn't run on server

[Eric]

I have Access 2000 loaded on a server running Windows
2000 for Small Business. When I try to run VBA code I
get the error...

Runtime error '429
ActiveX component can't create object

The code line where the stumbling occurs is:
Set db = currentDb

Any ideas where my problem is?

I know the code is correct as it runs fine on other
machines...servers and PC's. I loaded Office 2000
without a problem.

 

[Nikos Yannacopoulos]

Eric,

Long shot, but I suspect your project references a DAO object library
which does not exist on the server, or is not registered, or is simply
the wrong one (should be DAO 3.6 for A2K).
Start by checking the references (Tools > References in the VBA window).
Do you see the DAO 3.6 reference among the the selected ones at the top
of the list? If not, scroll down to find it (look for "Microsoft DAO 3.6
Object Library") and select it. If it's not there at all, check to see
if the .dll file (dao360.dll) exists on the server (typically in
C:\Program Files\Common Files\Microsoft Shared\DAO). If not, copy it
from another machine. In both cases, use Browse from the references
window to locate and "Open" (register) it.

HTH,
Nikos

 

[Eric]

Hole in ONE! The library reference was there but it
needed registration. Thanks.