Linked Table

[nadragon]

Hi,

I am trying to create a linked table to Oracle in MS Access, for the messages table.

When I sent out the message to one recipient, it was working.
However when I tried to send it to a group, it throwed the following messages.


1/31/2008 10:36:02 AM Program Halted. Database error: 3421 Data type conversion error. in Procedure: schedule_messages
1/31/2008 10:36:02 AM Restarting
1/31/2008 10:36:41 AM Module Started
1/31/2008 10:36:42 AM Running cleanup routine


Has anyone have this issue when using the linked tables?

Any suggestions would be greatly appreciated!
Thanks~

[Tech Support]

When you write a line to the messages table for a group, it requires different information in different fields than when writing a line for a regular recipient. Are you using the same structure for both?

[nadragon]

I am not writing the line in table directly, I am using the PG Admin to send the messages out.
It works fine with the original messages table. But that error occurs when using a linked table.

I think that the schedule_messages funciton tries to create a recipient schedule, and that error occurs, because the linked message table doesn't have the new lines for the recipients of the group.

Actually after I submitted the message to a group, the "scheduled" value is still 0, which means that it failed when it tries to schedule for the recipients in the group.

I hope that I didn't confuse you.
Thank you!!!