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