[volrathxp]

i have noticed a large amount of people having trouble w/ Access ActiveX components with error messages like "Runtime 429 error: ActiveX can't create component". have no fear all here is a link to technet for that exact error message and the workarounds for it. just go to Technet Article and check it out. One of the big major workarounds is registering the DAO (Data Access Objects) properly by going to the Start menu - > Run and typing in the following:

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO3032.dll"

w/ quotes and replace whatever is inside w/ wherever or whatever your dao dll is. (2000 uses a different DAO dll name so be careful).

Enjoy,

Joe Dyer

[RandyG]

That's a great tip for Access users, Joe!

Maybe one of the Moderators will move this to the Tips and Tricks forum.

In future, if you post it there, and label the Subject field more precisely, then it would be even better.

Please continue posting!

[~Candy~]

You've got it Randy....moving to tips!