1>做个数据表的TIGGER,例: CREATE TRIGGER trg_a ON tab_a FOR DELETE AS BEGIN INSERT *, * INTO SENDMAILTABL ()
END2>启动EMAIL SERVER SERVICE 随时读起 SENDMAILTABL的数据 有符合条件的数据就送信
如果我用的是Access 怎样办呢? 好象Access不能用触发器呀。
同意 xhuangp(老三) ,就是使用触发器。B. 使用带有提醒电子邮件的触发器 当 titles 表更改时,下例将电子邮件发送给指定的人员 (MaryM)。USE pubs IF EXISTS (SELECT name FROM sysobjects WHERE name = 'reminder' AND type = 'TR') DROP TRIGGER reminder GO CREATE TRIGGER reminder ON titles FOR INSERT, UPDATE, DELETE AS EXEC master..xp_sendmail 'MaryM', 'Don''t forget to print a report for the distributors.' GO
我说了,我用的是Access数据库,怎样做才好呢?
Access数据库的话, To create a trigger, click Tables under Objects in the Database window, and then right-click the table you want to define a trigger for. On the shortcut menu, click Triggers to open the Triggers for Table:
CREATE TRIGGER trg_a
ON tab_a
FOR DELETE
AS
BEGIN
INSERT *, * INTO SENDMAILTABL ()
END2>启动EMAIL SERVER SERVICE 随时读起 SENDMAILTABL的数据
有符合条件的数据就送信
好象Access不能用触发器呀。
当 titles 表更改时,下例将电子邮件发送给指定的人员 (MaryM)。USE pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'reminder' AND type = 'TR')
DROP TRIGGER reminder
GO
CREATE TRIGGER reminder
ON titles
FOR INSERT, UPDATE, DELETE
AS
EXEC master..xp_sendmail 'MaryM',
'Don''t forget to print a report for the distributors.'
GO
To create a trigger, click Tables under Objects in the Database window, and then right-click the table you want to define a trigger for. On the shortcut menu, click Triggers to open the Triggers for Table:
您能不能用中文写清楚一下。谢谢!!!
因我没有中文环境,可能讲不清楚.建议你找 以下开发工具看看:
Access Upsizing Tool
或 Access Developer*s Toolkit