I am running an MS Access 97 application were from 1 form I have a button to invoke Outlook Express.
On my test machine I run MS Access 97 under Windows XP home
I have 2 hard drives C: and G: to simulate the production system
MS Access is on the C: drive and the Access Application is also on the C: drive. The data is on the G: drive

On the Production system the data is on the Network server running under Windows 2000 and the application along with MS Access 97 is on each of the 2 stations running under Windows XP

The form has an EMail button supported by the following VB code

Private Sub Command183_Click()
Dim dbsSchoolSystem As Database
Dim rstStudent As Recordset
Dim SendEMail As String
SendEMail = Me!EMAILADD
DoCmd.SendObject acSendNoObject, , , SendEMail, , , "The Real Estate Training Institute", "We just received the course material today!char(13)Have a good day"
'rstStudent.Close
End Sub

On the test machine when I click on the EMail button it envokes Outlook Express and I can send an EMail

On the production machine when I click on the EMail button I receive the following Error Message

Run-Time Error 2046
The Command or Action "Send Object: isn't available now

I am at a loss why it works on the test machine and not on the production machine. Any ideas are appreciated

Hi gordheck

It gives the impression that there in no reference to Outlook Express in the production version of the database. Check to see if this has a reference and if not add it, if so, let me know

Best

Martin

Hi there.

Take a look at method 2 in:-

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

I have an access2003 database running on Win XP. It uses SendObject to send reports as email messages using Outlook Express. Recently when I installed an update for Office 2003, my default email program somehow got changed to Outlook. I changed it back to Outlook Express, but when I tried emailing from my access program I got that dreaded "...isn't available now message". I poked around on the internet looking for a solution and eventually found the above solution, and it cured my problem.

I guess that the Office update, or the removal of Outlook must have removed those registry entries.

John

Hi Martin.
Thank you for your response to my problem
If I understand you correctly when you said to check the reference
I went into the MS Access Application and opened the Visual Basic for the SEND EMAIL button
I checked the REFERENCES on both computers and each had the first only the first four checked
Visual Basic for Applications
Microsoft Access 8.0 Object Library
Microsoft DAO 3.51 Object Library
Microsoft Word 8.0 Object Library

Any other ideas