ÈçºÎ»ñÈ¡AccessÊý¾Ý±íµÄ´´½¨±í½á¹¹Óï¾ä£¿
ÈçÌ⣬һ¸öACCESSÊý¾Ý¿âÖÐÒѾ´´½¨ÁËÊ®À´¸öÊý¾Ý±í£¬ÎÒÏ뽫ʵÏÖËùÓÐÕâЩ±í¸ñ½á¹¹Äܹ»Éú³É±ê×¼µÄCreate Table SQLÓï¾ä£¬È»ºóÀûÓÃÕâЩSQLÓï¾ä£¬ÄÜÔÚÁíÒ»ACCESSÊý¾Ý¿âÖÐÔËÐУ¬´´½¨¸úǰһACCESSÊý¾Ý¿âͬÑù½á¹¹µÄÊý¾Ý±í¡£ÇëÎÊÈçºÎʵÏÖ£¿Ð»Ð»£¡
ÓÃCHANGE×÷¹Ø¼ü×Ö£¬Ã»ÓÐËÑË÷µ½
лл£¬°´ÕÕÄãÌṩµÄ·½·¨ÒѾ¸ã¶¨
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......