473,372 Members | 842 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Send Groupwise Email in Access Problem

Hi
I've been happily using Dimitri Furman's email code to send messages but since upgrading to Groupwise 7 i've hit a slight problem. The code works great and sends the email as expected, however if you specify a proxy account to send the message from it does this, sends the email and then Access crashes (generic, Access has encountered and error message). I can't seem to find out where its crashing, no error messages etc, debugging doesn't show anything.
As everything still works great with older versions of Groupwise i'm guessing the problem is there, has anyone else had this problem? Or does anyone have any ideas how to find out either what is wrong or how to fix it?

Thanks
Mar 29 '07 #1
13 4387
MMcCarthy
14,534 Expert Mod 8TB
Hi
I've been happily using Dimitri Furman's email code to send messages but since upgrading to Groupwise 7 i've hit a slight problem. The code works great and sends the email as expected, however if you specify a proxy account to send the message from it does this, sends the email and then Access crashes (generic, Access has encountered and error message). I can't seem to find out where its crashing, no error messages etc, debugging doesn't show anything.
As everything still works great with older versions of Groupwise i'm guessing the problem is there, has anyone else had this problem? Or does anyone have any ideas how to find out either what is wrong or how to fix it?

Thanks
I'm afraid I haven't used this class so can't be of much help. Have you set breakpoints in the code to try to find out what statement is triggering the problem.
Mar 30 '07 #2
I'm afraid I haven't used this class so can't be of much help. Have you set breakpoints in the code to try to find out what statement is triggering the problem.
I have tried that, but it hasn't helped much, there doesn't seem to be a statement causing it. Its a strange problem. The code works, sends everything as expected and then Access crashes. I've debugged through the code and it falls over when the class module is terminating but all i get is error number 0, no description, no source and i can't trap it or ignore or anything. (And, i was under the impression that 0 meant there was no error?)
I tried commenting out the bit where i set the class to nothing (bypassing the class termination bit) and it still crashes, doesn't go to any of the error trapping code.
And, I've also looked in the event viewer on my PC and it just says that Access faulted in an unknown module

I'm wondering if Groupwise is returning an error and Access can't cope but i don't know how to check for this (or is it possible?)
Mar 30 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
I'll ask some of the other experts to have a look. They may have some insight into this.

Mary
Mar 30 '07 #4
developing
110 100+
what version of access
Mar 30 '07 #5
ADezii
8,834 Expert 8TB
I have tried that, but it hasn't helped much, there doesn't seem to be a statement causing it. Its a strange problem. The code works, sends everything as expected and then Access crashes. I've debugged through the code and it falls over when the class module is terminating but all i get is error number 0, no description, no source and i can't trap it or ignore or anything. (And, i was under the impression that 0 meant there was no error?)
I tried commenting out the bit where i set the class to nothing (bypassing the class termination bit) and it still crashes, doesn't go to any of the error trapping code.
And, I've also looked in the event viewer on my PC and it just says that Access faulted in an unknown module

I'm wondering if Groupwise is returning an error and Access can't cope but i don't know how to check for this (or is it possible?)
This is a long shot but it is worth an attempt:

__1. Within the VBA IDE
__2. Tools ==> Options ==> General ==> Error Trapping
__3. Select Break on Unhandled Errors NOT Break in Class Module
__4. See what happens next

NOTE: You are correct about Error Number = 0, in that this usually indicates that an Error did not occur during a process, and is actually used within an expression (Err.Number <> 0) to indicate the existence of an Error Free state.
Mar 30 '07 #6
NeoPa
32,556 Expert Mod 16PB
I can't be much help, I'm afraid.
I have had some experience of Access crashing in a similar way (Spurious error message - No way I could find of determining where (if at all) there is any problem in my code), but eventually had to put it down to Access being poorly written as far as error handling and reporting goes.
Mar 30 '07 #7
Denburt
1,356 Expert 1GB
Not much help here either, I have limited experience with Groupwise, I have had sporadic crashes in the past in certain areas and the only way I found it was by importing everything into a new DB and found out a certain form had issues. I know this sucks as a solution. Hopefully Adezii's idea will work.
Mar 30 '07 #8
Thanks for the replies, and here's the answers to your questions

This is happening in Access97, 2003 and a runtime 2003.
I've tried all 3 error handling options and the end result is always the same. When the class terminates so does Access, with no error present, its always 0.
Its also happening in different databases, with different forms etc. I tried copying it into a fresh database but it made no difference. (and it does work fine on pcs with earlier versions of groupwise so i didn't think this was the problem)

It's annoying because if you ignore the fact Access crashes it all works perfectly :)
Mar 30 '07 #9
NeoPa
32,556 Expert Mod 16PB
That has to be a problem with the new version of the GroupWise library then I would say. Possibly could be handled better by Access, but surely a problem with the lib fundamentally.
Mar 30 '07 #10
Denburt
1,356 Expert 1GB
There is always the decompile option but I would be very carefull and backup the db first. This has saved me a couple of times but I have heard that it can turn your BD into Swiss Cheese although I have not had it happen yet.

Create a shortcut and use the following as a command line (Target)

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\MyDBFolder\MyDB.mdb" /decompile

The Start in would be the directory where MS access itself is located.
"C:\Program Files\Microsoft Office\Office11"

Or just use the run command and of it goes.
Mar 30 '07 #11
Haveing this problem as well. Have you found any workarounds?

Hi
I've been happily using Dimitri Furman's email code to send messages but since upgrading to Groupwise 7 i've hit a slight problem. The code works great and sends the email as expected, however if you specify a proxy account to send the message from it does this, sends the email and then Access crashes (generic, Access has encountered and error message). I can't seem to find out where its crashing, no error messages etc, debugging doesn't show anything.
As everything still works great with older versions of Groupwise i'm guessing the problem is there, has anyone else had this problem? Or does anyone have any ideas how to find out either what is wrong or how to fix it?

Thanks
Sep 12 '07 #12
NeoPa
32,556 Expert Mod 16PB
Only what's in the thread Roy.
Sep 13 '07 #13
Have you found the solution ? I have the same problem.
Nov 4 '14 #14

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Dennis Hartmann | last post by:
Has anyone found a "display" method for the GroupwareTypeLibrary.Message object, comparable to the Display method of the Outlook.MailItem object? I simply want end user or have the option of...
2
by: Norman Fritag | last post by:
Hi there are there any issues with sending multiple emails via GroupWise ver. 6??? please comment. Regards Norman
1
by: Molly J. Fagan | last post by:
Hello everyone-- I'm trying to develop a help desk system to replace Trak-It. We have a help desk e-mail address and want all messages sent to that e-mail address to go into an Access database...
5
by: Laertes | last post by:
Hi, I know there is already a plethora of emails regarding Groupwise/Access problems but mine is slightly different to the ones I've read about. I'm trying to use the sendobject command to...
4
by: Rvo | last post by:
Hi all, I need to use the Netware "send" function to send messages to some/all attached netware users on a server. However, I can't find any documentation on this topic on the Novell site or...
5
by: amjad | last post by:
hi how to send email through groupwise not smtp with asp.net 1.1 lang=c sharp.. thanks
3
by: Aaronindm | last post by:
I have used DoCmd.SendObject to send an e-mail through Access. Now I am looking for a way to attach a file (e.g. PDF file) to that document. I think this is possible using Outlook but cannot find...
5
cori25
by: cori25 | last post by:
Hi, I have been trying to come up with a module in access using VB to allow email messages to be sent using GroupWise. I am having a hard time and was wondering if anyone has any experience with...
1
by: ncsthbell | last post by:
I saw a thread from last October with 'Tara99' where she apparently was trying to do exactly what I need to do, send enails from access using Groupwise. However, I did not see in the end where or if...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.