ACCESS VBA ¹ØÓÚÊý¾Ý±£´æµÄÎÊÌâ
´ÓTBL_1È¡³öÊý¾Ýºó£¬ÓñíµÄÐÎʽ½«Êý¾ÝÏÔʾÔÚFORM_1`ÉÏ
È»ºóÔÚ½øÐÐÐÞ¸Äʱ£¬ÏëÒ»´ÎÐ޸ĶàÌõ¼Ç¼£¬È»ºó±£´æµ½TBL_1
Èç¹ûҪʵÏÖÒÔÉÏ´¦Àí£¬Ó¦¸ÃÔõô×ö£¿
Çë¸ßÊÖÖ¸½Ì£¬Ð»Ð»ÁË
Â¥Ö÷ÃèÊöµÄÓ¦¸ÃÊÇDBGrid»òDataGridµÄ¹¦ÄÜ£¬ÎÒûװµÄAccessÈí¼þ£¬ÄãÕÒһϿ´¿´£¬ÓÐÎÊÌâ¿ÉÒÔ¼ÌÐøÎÊ¡£
ÎÒÕ⼸ÌìÒ²ÔÚ×öÒ»¸öaccessµÄ¹¤¾ß£¬µ«Êǽè1Â¥µÄ»Ø¸´£¬accessÖкÃÏñûÓÐdataGrid£¬flexgridÖ®ÀàµÄ¿Ø¼þ¡£
Â¥Ö÷¿ÉÒÔ¿¼ÂÇÓÃlistbox
Ïà¹ØÎÊ´ð£º
ÕâÁ½Ììѧϰ¡¶Delphi¼¼Êõ·½°¸±¦µä¡·Ò»ÊéÖеÚÈýÕ¹ØÓÚÓû§µÇ¼·½°¸µÄÀý×Ó£¬ÀûÓõÄÊÇSQl ServerÊý¾Ý¿âʵÏÖÓû§µÇ¼£¬±àÒëÔËÐж¼Ã»ÎÊÌ⣬¸ÃʵÏֵŦÄÜÒ²¶¼ÊµÏֵĺܺ㬵«ÊÇÆæ¹ÖµÄÊÇ£¬·´¸´ÔËÐÐÒ»¶Îʱ¼äºó£¬ÓÐʱÔڹرÕÕû¸ö ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿
Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
ÎÒÔÚCBÁ·´´½¨ACCESSÎļþ£¬
²ÉÓõÄÏÂÁдúÂë,ÎÒרÃÅÏÈ×ö¸öС³ÌÐò²âÊÔ£¬Ò»ÇÐÕý³£¡£
È»ºóÔÚ¼ÓÔØµ½1¸öÈí¼þÖУ¬
´«ÈëµÄ±äÁ¿MDB_PathNameÒ²ÊÇÕýÈ·µÄ¡£
µ«ÔÚÖ´ÐÐ
mdb.OleFunction("Create", ......
²éÁ˺ó¤ºÃ³¤Ê±¼ä£¬ÎÊÌâÖÕÓÚ½â¾ö£¬Ï£ÍûÓÐÕâÑùµÄÎÊÌâµÄÅóÓÑÉÙ×ßЩÍä·¡£
×¢Ò⣬ÎÒÕâÀïʱºòËù˵µÄÊÇÖ»ÓÐÒýÓÃÊý¾Ý¿âµÄÖÐÎÄÂÒÂë£¬Ò³ÃæÆäËûÖÐÎÄÕý³££¬ÆäËûÇé¿öÔò²»Ò»¶¨ÊÊÓá£
ÔÚÏÖÊµÒ³Ãæ×î¶¥¶Ë¼ÓÈëÏÂÃæÁ½¾ä£º
......