Web Development

Ask something
Discussion Locked

MS Access Illegal Operation Error

0 helpful
3 replies

by agtcna

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am developing an Access Application wherein I use the SendObject function of DoCmd. The application works fine on my local workstation, but when I moved it to our NT Server for multi-user access and the program is executed, I get an "Illegal Operation" error whereby "MSAccess caused an invalid page fault in module KERNEL32.DLL ...........".
If I comment out the line of code containing the DoCmd.SendObject, everything works fine
(i.e. no invalid page fault). The Server is a Compaq Proliant6000, with four Xeon400
processors, 512MB RAM, running NT4 SP6a.

3 replies

by sl-campbell

According to MS Kb Artikle Q260819 the cause of the problem could be one of two things:

1). There are too many characters in the message. This behavior has been documented with messages that contain between 98 and 2268 characters.
To correct: This reduce the message length.

2). The SendObject method runs more than one time in a procedure.

To correct this: When you only need to send a message without attaching Access objects, send the message by automating the Outlook or Collaborative Data Objects (CDO) object libraries.

For more help go to the MS Kb and do a search on the above artikle or use the following address:

http://support.microsoft.com/support/kb/articles/Q260/8/ 19.ASP?LN=EN-US&SD=gn&FR=0&qry=SendObject%20%20%26quot%3BMSA ccess%20caused%20an%20invalid%20page%20fault%20in%20module%2 0KERNEL32.DLL%26quot%3B&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=MSA LL

(Watch out for any spaces in the URL)

by agtcna

Thanks for the reply. Not sure if this will help, but I will have to study it in depth as it is not the easy proble, (character number in message), but seems to be Server-Oriented.

This discussion is closed to new replies.