Access and Outlook 2000 Not Communicating Well - Any Ideas?

[roxannep]

I converted a database from 97 to 2000 wherein I have emails going to recipients. The email is in VB and the recipients and variables are pulled into a table via MakeTableQuery based on my criteria. This all worked lickety-split fine in '97 versions with Access dumping out each recipient's customized email message to Outlook, and Outlook sending them on out as it does.

HOWEVER, when I switched to 2000, this same code or something between the programs "hitches." Sometimes the first 3 messages make it out to Outlook, then Access crashes, sometimes 44 make it out, and sometimes whatever number is in the table make it out without a problem!

I know nothing of Page Fault errors and don't know if this is Access or Microsoft 2000 programming in general or my install of the program (or loss of a file) that is now not letting these two programs communicate as they did in '97. I am having this problem on two completely separate PCs (literally physically separated by miles). Below is the Page Fault error I receive if anyone has a clue on this.

Any ideas, suggestions, workarounds?

MSACCESS caused an invalid page fault in
module KERNEL32.DLL at 014f:bff78053.
Registers:
EAX=05736164 CS=014f EIP=bff78053 EFLGS=00010206
EBX=06cbf2c4 SS=0157 ESP=00626924 EBP=00006cc0
ECX=6e6f6320 DS=0157 ESI=06cbf1e0 FS=0f27
EDX=74636174 ES=0157 EDI=05736248 GS=0000
Bytes at CS:EIP:
89 51 08 8b 53 08 8b 43 04 8d 8b 0b 10 00 00 c1
Stack dump:
00006cc0 000000e4 06cbf1c4 0000001c bff782c8 06bc0000 06cbf1e0 000000e4 00000000 06cbf1c4 06bc0000 00000040 06bc000c 00006cbf 00000000 00000040

 

[DougP]

Is this happening In VB or where.
How empty is your hard drive and how Much Ram do you have.

try re-booting after a crash and see if the e-mails will go out, not making any other changes.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[roxannep]

It doesn't indicate where it's going haywire. I have found from other forums I'm not the only one running into this, but have yet to find a solution.

I have rebooted, rebooted, and rebooted. Emails will stack in Outlook a few at a time, randomly (not the same number making it through each time before the crash), and once there, they go out normally. The problem is getting Access to send them all at once in a few minutes' time as it used to. The email instructions are in VB, along with a select statement depending on variables in each record. Again, this worked flawlessly in '97 Access and Outlook, but not in 2000.

The solution another programmer used was to RETURN TO '97. I don't have that luxury at this point (not my decision). So, I'm still looking for an alternative answer.