Hello, i have set up a database and have put code to send an email when a command button is pushed. I used the safemail code and everything on my computer and it works just fine. The problem is we are a company of 300 and all will have to access this database at some point. Everytime i open the database from a different computer i get an error Runtime error 429 Active X componet can't create object. The line of code below is what is highlighted when i debug. Any help with the least amount of troubles would be great.

Set safemail = CreateObject("Redemption.SafeMailItem")

Not familiar with "SafeMail" (?), but I'm wagering a guess that it is an Object file (DLL,OCX) that is a selected Object in your application (VB Editor|Tools|References), and you have not copied this object file to the other workstation. You can tell by opening your database in Design Mode on any of the other computers. Open the VB Editor, Click Tools|Relationships, and see if any of the checked References have "IS MISSING" beside them.

SafeMail sounds interesting -- have a good URL for it?

You will probably need to purchase the Outlook Redemption - distributable version . See this page


John,
check out this page

Thanks Boyd. Yea, I've been to the OR page. Haven't tried using the object yet. I was curious about "SafeMail", if that is something different? A couple apps I am working on sends email via SendObject, so will want to changeover to OR before it is finalized.

I have run into this problem and it is because redemption (safemail) was not installed on the computer using the program. I have also run into situations were redemption seems to become corrupt and we have to reinstall redemption.
hth,
Stephen