sending email with attachment with VBA in access 2000

Hi,
I'm trying to send an email with an attachment using VBA and Access 2000. this wokred with CDONTS but stopped working after a recent set of MS updates.  we are trying to use CDO (CDOSYS.DLL) but getting an error. works when the program is logged on (they have admin rights) but user cannot send and gets an error - I'll get the error code.

the setup is:
Server 2003 X64 running terminal server (remote desktop)
Access 2000
VBA
Outlook is not installed on this system

trying to move way from CDONTS and use CDO (or whatever is supported at this time - is there a better way?)

Worth 500 points - we have wasted a few days on this and need to move foward

thanks!
ifotoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
CDO is fairly simple to use, and is very similar to CDONTS. Here's a good starting point:

http://www.rondebruin.nl/cdo.htm

This is marked for Excel, but will work with any flavor of VBA.

Here's another:

http://support.microsoft.com/kb/161833

If you cannot get those to work, post your own code (using CDO) and indicate where you're having troubles.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ifotoAuthor Commented:
I posed the code and it seems to be also related to if the user has administrators  (group)
again it works for our programmer (she is logged on as a administrators equivalent) and we are on a server 2003 running Remote Desktop Services

of course I don't want all my users to be admins.
0
ifotoAuthor Commented:
not sure if this fixed the problem - but I unregistered CDONTS and that seemed to fix the problem
0
ifotoAuthor Commented:
this was all information I had already found so it was the right stuff.
My issue seemed to be unique. and still not sure what the cause was but removing CDONTS from the VB program seemed to solve the problem
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.