Error:429;ActiveX component can't create object

[ChristyG]

I'm not sure if this is a Query problem or a Report problem, so I'm putting it in the General catagory. If I need to post it in one of the others, please point me the right direction.


I have set up the following:

Query A - Combines data from several tables
Query B - Prompts for a text string and places it in a table
Query C - Uses the text entered in Query B to select records from Query A. The field that is searched is a text field.
Report A – Has an Open procedure that executes a macro that runs Query A. I also have a Close procedure that executes a macro that runs a second report based on Query A against a different table.

When I run the report on my desktop it works properly. I had a user try to run the report and she gets the following error immediately, prior to being prompted for the text.

Error:429;ActiveX component can't create object


I am running Office XP and she is running 2003 with SP2. She has not had problems with other Access reports in the same DB. Any ideas what is missing?

Thanks,
Christy

 

[apr pillai]

Probably you are using an Expression in your Query that needs a Library Version compatable to both of your machine. Go to your colleague's PC, open the Code window, Select Tools-->References and look for any missing item in the selected Library List. If there is one, then select a compatable Microsoft ActiveX Data Object Version and Microsoft DAO Object Library Version and try it out.

visit my site : http://msaccessblog.blogspot.com/ for tips and tricks in Form Designing.