ADOXΪaccessÌí¼ÓÓû§(VC)
ÈçºÎÔÚvcÖÐʹÓÃADOXΪaccessÊý¾Ý¿âÌí¼ÓÒ»¸öÓû§?
лл!
ßí?ÔõôûÈËÀ´¿´¿´Ñ½?
ÎÒŪ ÁË ºÃ¾ÃÁË,¶¼Ã»Ò»µãÍ·Ð÷!
ÄÇλ´ó´óÀ´¾È¾È¼±Ñ½!
ллÁË!
Ìí¼ÓÒ»¸öÓû§ÊÇʲôÒâ˼£¿£¿Ìí¼ÓÒ»ÕÅ±í£¿£¿»¹ÊÇ´´½¨Ò»¸öеÄÊý¾Ý¿â£¿
ADOX.AppendUser
Users.Append User[,Password]
ºÜÈÝÒ׵ģ¬MSDNÉÏÓÐVB´úÂ룬»»³ÉVCµÄ¾ÍÐÐÁË
¿´¿´Õâ¸öÍøÒ³°Éhttp://topic.csdn.net/t/20050207/16/3779720.html
ÎÒ¶¼ÊÔ¹ýÁË,µ«ÊÇÓдíÎó,ÎÒÐèÒªÒ»¸öÇÐʵ¿ÉÐеÄVCµÄÀý×Ó!
accessÖ§³Ö¶àÓû§Ñ½,ÎÒÏëÔÚÎÒ´´½¨µÄaccessÊý¾Ý¿âÉÏ,ÔÚÌí¼ÓÒ»¸öÊôÓÚ "¹ÜÀíÔ±"×é±ðµÄÓû§!
ÎÒÒѾ²éÕÒÒ»ÌìÁË,ûÓÐVCµÄÀý×Ó,VBµÄÀý×ÓÎÒת»»µÄ¿ÉÄܲ»¶Ô,×ÜÊÇÓдíÎó,ËùÒÔ,ÎÒÏ£ÍûÄÜ¿´µ½Ò»·ÝÄÜÕý³£ÔËÐÐµÄ VCÔ´´úÂë,¾ÍÒªÌí¼ÓÓû§µÄÕâÒ»¶Î¾ÍÐÐ!
´ó´óÄܸøÎÒÕâ¶ÎVC µÄ´úÂëÂð?
ÎÒ×Ô¼º×ª»»µÄʧ°ÜÁË,²»ÄܽøÐÐÌí¼Ó!
´ò¿ªÄǸösystem.mdwµÄÁ¬½Ó´®×ÜÊDz»¶Ô,¶øÇÒ,ҲûÓÐUser.NameÕâ¸öÊôÐÔѽ!
½¯ÀÏ´óµÄÌṩ¼«Æ侫׼
Ì«¸Ðл
jiangsheng
(½¯êÉ)
´ó´óÁË
ż¶¼¿à¿àµÄÕÒÁËÒ»ÌìÁË,ÔÚMSDNÉÏ·ÁË°ëÌìҲûÕÒµ½@
лл!
Æ
Ïà¹ØÎÊ´ð£º
Çë½Ì¸ßÊÖ2¸öÎÊÌ⣺
1¡¢¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌ⣻ÔõôÏÂÃæ´úÂëÎÞ·¨´ò¿ªÊý¾Ý¿âѽ£¿
2¡¢ÏÂÃæµÄ´úÂë¿ÉÒÔ·ÃÎÊ¡°¹ú±êÂ롱×Ö¶ÎÖеÄËùÓмǼֵÂð£¿
¼±¼±£¡£¡£¡£¡£¡£¡£¡£¡
vbÓïÑÔ´úÂëÈ ......
ÎÒ½¨Á¢2¸ö±í,±ÈÈçtable a table b
¼ÙÈçÎÒtable a µÄÖµµÃÊÇÍøÒ³Ìá½»ÊäÈë½øÀ´..
Äܲ»ÄÜÔÚaccessÓмÆË㹦ÄÜ,¼ÆËã½á¹û¸³Óètable b
Èç: ta ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎÎ ......
´úÂ룺Dim ConnStr
connstr="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=c:\a\xueziArticle.mdb;"
Const sCacheName="NB743969143"
Set Conn = Server.CreateObject("ADODB ......