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.

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 wrote:
> 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.

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

>-----Original Message-----
>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 wrote:
>> 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.
>.
>