Hi, I have one of my team out on site training one of our databases (An Access ADP connected to SQL 2000) to a client. On one of the client machines whenever they try to do something involving Email it stops with the following error:
Run time error 429: ActiveX Component can't generate object.
We have pinned the error down to one line:
Dim appOutlook As Object
Set appOutlook = CreateObject("Outlook.application") <-- this line here
(note that we have to use late binding because of different versions of Outlook on the clients)
There seems to be a lot written about this problem but none seem to fit exactly with my circumstances.
The client PC has Access 2000 installed (which shouldn't be used for our app), Outlook 2003 and then our application which uses the Access 2003 runtime.
The PC next to it is identically setup and doesn't have the same issue.
I have tried reinstalling the access 2003 runtime package to no avail.
Does anyone have any suggestions please?