accessÖÐʹÓÃtableÈ·¶¨Î»ÖÃ
¡¡¡¡²»ÖªµÀaccessÖÐÊÇ·ñÄܹ»Ê¹ÓÃtableÀ´½«¸÷¸ö¿Ø¼þ·ÅÈëÏàÓ¦µÄtableµÄ¸÷¸ö¸ñ×ÓÖУ¬¾Í¸úvsµÄaspÒ»Ñù¡£ÔÚdesignÖÐûÓÐÕÒµ½¿ÉÒÔÔÚÒ³ÃæÖгÊÏÖÒ»¸ötableµÄ¹¤¾ß£¬Ïò´ó¼ÒÇó½Ì£ºaccessµ½µ×ÊÇ·ñÓÐÕâÑùµÄ¹¤¾ß£¿
¿´À´£¬accessµÄ½çÃæ¹¦ÄÜ»¹ÊÇûÓÐvsÇ¿´ó£¬ºÇºÇ£¡
ÓÃÁËÒ»¸ösub form£¬Ò²²»ÊǺܺÃÓá£
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
ÎÒÔÚSQL2000ÖÐÏÂÃæµÄÕâ¾äÊÇûÎÊÌâµÄ,¿Éµ½ÁËaccessÀï¾Í»áÁË´í
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpa ......
ÇëÎÊ£ºÓÃsqlÓï¾ä´´½¨Access2000Êý¾Ý±íʱ£¬ÈçºÎÉèÖÃij×Ö¶Î(Èç:Field1)ÔÊÐíΪ¡°¿Õ×Ö·û´®¡±
ÎÒÓô˷¨ Create Table MyTable( Field1 VarChar(10) Null , Field2 DateTime Null £©
²»ÄÜÉèΪ¡°¿Õ×Ö·û´®¡±
ÔÚVarC ......