Error code 2293-Access 2003

Topic

New Reply

I have a database that uses the following On click event code

Private Sub cmdPrintSecurityDepositRefund_Click()
If [TrfDepositCheckBox] = -1 Then
Me.DepositRefundAmt = 999
Else: Me.DepositRefundAmt = Me.NetDepositAmt
End If

DoCmd.OpenReport “rptSecurityDepositRefund”

DoCmd.SendObject acSendReport, “rptSecurityDepositRefund”, acFormatSNP, “asacorp@sc.rr.com”, , , “Security Deposit Refund Report”, “The Security Deposit Refund Report is attached as a snapshop file”, True
DoCmd.Close acReport, “rptSecurityDepositRefund”, acSaveNo
DoCmd.Close acForm, “frmSecurityDepositRefund”, acSaveNo
DoCmd.Close acForm, “frmCheckOut”, acSaveNo

End Sub
The code has been working for years at number of installations but one user recently upgraded to Windows 7 and is using Outlook 2003 SP3. The report opens fine and a hard copy can be printed but a runtime error 2293 is received when it tries to E-mail the snap report.

Any suggestions.

Tom Goodwin

Reply | Quote

Replies

Tom,

If I remember correctly, I do not think Windows Version 7 is compatible with the Snapshot Viewer which would cause the error.

Reply | Quote

Thanks. I am not trying to read the SNP file in Windows 7 but to E-mail it to a user that is using Windows XP. The addressee has no problem reading SNP files send from other non Windows 7 users. It seems to me the problem must be some conflict between Access and Outlook rather than Windows 7 but I have never used Windows 7. I am guessing it is some type of security issue in Outlook but I am a non-Outlook user so really don’t know where to begin.

The DoCmd.SendObject has a True/False augment that deals with the ability of the sender to edit the email. It is currently set to True and we will try to see if changing it to false makes a difference. The problem computer is remote from my location and we probable won’t be able to experiment until early next week.

Reply | Quote

This Microsoft support document Outlook Error 2293 may be useful in chasing down what the issue is.

Reply | Quote