ÈçºÎ±àдһ¸ö¶¨Ê±±¸·ÝACCESSÊý¾Ý¿âµÄ³ÌÐò£¿
×î½üÔÚ×öÒ»¸öÊý¾Ý¿âÏîÄ¿£¬Ê¹ÓõÄÊÇVBScript+Access£¬ÏÖÔÚÐèҪʵÏÖÊý¾Ý¿âµÄ¶¨ÆÚ×Ô¶¯±¸·Ý£¬±ÈÈçÿÖÜÒ»ÉÏÎç10µã£¬ÇëÎÊÕâ¸ö¶¨Ê±³ÌÐò¸ÃÈçºÎд£¿
windowsµÄϵͳ¼Æ»®ÈÎÎñÀïÖ´ÐÐÄãµÄ±¸·Ý³ÌÐò¼´¿É
VBScriptµ÷ÓÃAPI¶àýÌ嶨ʱÆ÷£¨timeSetEvent£©£¬ÔÚ¶àýÌ嶨ʱÆ÷ÀïÅжÏʱ¼ä²¢±¸·ÝaccessÊý¾Ý¿â¡£
ÔõÑù°Ñ³ÌÐò×Ô¶¯¼ÓÈëµ½¼Æ»®ÈÎÎñ£¿
Õâ¸ö³ÌÐòÊǺܶà»úÆ÷¶ÀÁ¢Ê¹ÓÃ
Õâ¸öÈç¹ûÍøÒ³Ã»Óдò¿ª¿ÉÒÔ±¸·ÝÂð£¿
ÓñðµÄÓïÑÔʵÏÖÒ²¿ÉÒÔ£¬Õâ¸ö±¸·Ý³ÌÐòÏ൱ÓÚ¶ÀÁ¢ÓÚÖ÷ÌåÖ®ÍâµÄ
ÓÐÈËÄܰï°ïÎÒÂð£¿
Æ®¹ý¡£
°Ñ³ÌÐò×Ô¶¯¼ÓÈëµ½¼Æ»®ÈÎÎñ¿ÉÒÔÓÃ
shell ("cmd /c at ...")
¾ßÌåÇë²Î¿¼atÃüÁîµÄÓï·¨
²»¿ÉÄÜʵÏÖ£¬accessÈç¹ûÊÇ´ò¿ª×´Ì¬£¬Äãû°ì·¨±¸·ÝµÄ¡£
µ±È»Èç¹ûÈç¹ûÊÇÈ·¶¨accessûÓдò¿ª£¬ÄÇô¶¨Ê±±¸·Ý²Å¿ÉÄÜ×öµÃÁË¡£
Ïà¹ØÎÊ´ð£º
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ACCESSÊý¾Ý¿âÖÐÓÐ×Ô¶¯Ôö¼ÓµÄ×Ö¶Î ID£¬Êý¾Ý¿âµÄ×Ö¶ÎÃû¼°¸ñʽÈçÏ£º
ID dValue0 dValue1 dValue2 dValue3 dValue4 dValue5
&nbs ......