Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

VC/MFCÖеÄACCESSÊý¾Ý¿â·ÃÎÊʵÏÖ(·½·¨2)

½ÓÉÏÃæµÄһƪ¡£
·½·¨2£º
´´½¨Ò»¸öµ¥ÎĵµÓ¦ÓóÌÐò -> ÏÂÒ»²½ -> Ñ¡Ôñ Database view without file support £¬
µ¥»÷ Data Source ÔÚµ¯³öµÄ "Êý¾ÝÁ¬½ÓÊôÐÔ" ¶Ô»°¿òÖУ¬Ñ¡Ôñ " Microsoft Jet 4.0 OLE DB Provider " ¡£
µ¥»÷ ÏÂÒ»²½ ÔÚ"Ñ¡Ôñ»òÊäÈëÊý¾Ý¿âÃû³Æ ÖУ¬Ñ¡Ôñ Êý¾Ý¿âÎļþËùÔڵķ¾¶¡£Í¬µÚһƪËùÊö·½·¨£¬Ê¹ÓÃĬÈϵĿհ×ÃÜÂë µ¥»÷ "²âÊÔÁ¬½Ó" Ìáʾ " Á¬½Ó³É¹¦" µã»÷ È·¶¨ £¨ÔÚ VC6.0 Ï£¬»áÌáʾ"ÇëÑ¡ÔñÊý¾Ý±í" Ñ¡ÖÐ×Ô¼ºËù´´½¨µÄ±íÃû×Ö¼´¿É-> È·¶¨£©
»Øµ½Ó¦ÓóÌÐòÏòµ¼£¬ºóÃæµÄʹÓÃĬÈÏÖµ¾Í¿ÉÒÔ¡£
Íê³ÉÒԺ󣬿ÉÒÔÔÚ Ö÷³ÌÐòµÄ¶Ô»°¿òÖУ¬Ìí¼ÓÒ»¸ö°´Å¦£¬ÔÚ°´Å¦µÄÏìÓ¦º¯ÊýÖмÓÈë¶ÔÊý¾Ý¿â³ÉÔ±µÄÖ±½Ó¸³Öµ¾Í¿ÉÒÔ£¬ÀýÈ磬ÎÒµÄÊý¾Ý¿â±í½á¹¹ÈçÏ£º
ID ×Ô¶¯Ôö³¤£¬Ö÷¼ü¡£
Óû§ÃûSUserName ×Ö·ûÐÍ
Óû§ÐÔ±ðSSex        ×Ö·ûÐÍ
ÎÒÏëÔö¼ÓÒ»ÌõеÄÊý¾Ý£ºÕÅÈý ÄÐÄÇô£¬
Ö±½ÓÔÚ°´Å¦µÄÏìÓ¦º¯ÊýÖÐдÉÏ£º
m_pSet->AddNew();
m_pSet->m_SUserName = "ÕÅÈý";
m_pSet->m_SSex           = "ÄÐ" ;
m_pSet->Update();
¾Í¿ÉÒÔʵÏÖ¶ÔÊý¾Ý¿âµÄ²Ù×÷¡£
PS: ÕâÖÖ·½·¨ºÜ·½±ã£¬ÀàÏòµ¼×Ô¶¯¸ø´´½¨ÁËÒ»¸öÊý¾Ý¿â²Ù×÷µÄÀࣺC¹¤³ÌÃûSet ËüÊÇCResordSetµÄÒ»¸ö¼Ì³ÐÀà¡£ÀïÃæ¶ÔÊý¾Ý¿âÖÐµÄ±í½øÁË×Ô¶¯µÄ´¦Àí£¬ÎªÃ¿Ò»Ïî´´½¨ÁËÒ»¸ö±äÁ¿¡£ÎÒÃÇÖ»ÐèÒª½øÐв¢Ìí¼Ó£¬¸øÃ¿¸ö±äÁ¿¸³Öµ£¬¸üУ¬ÕâÑùµÄ²Ù×÷£¬¾Í¿ÉÒÔÍê³É¶ÔÊý¾Ý¿âµÄ´¦Àí¡£
¾ßÌåµÄÀý×Ó¿ÉÒԲο¼ÍøÉϵÄÕâÆªÎÄÕ£ºhttp://www.yesky.com/259/1807259.shtml 
ËüÐèÒªÓû§´´½¨Ò»¸öÊý¾ÝÔ´£¬²¢Ñ¡ÔñÏàÓ¦µÄÓû§±íºó²Å¿ÉÒÔ¡£
µÚ¶þÖÖ·½·¨½áÊø¡£


Ïà¹ØÎĵµ£º

ACCESSÊý¾Ý¿âµ½SQLÊý¾Ý¿â

 ´ÓAccessÊý¾Ý¿âµ¼Èëµ½SQL
·½·¨Ò»:
ÔÚMSsqlÖÐÒª¼òÀúODBC..·½·¨±È½Ï±¿µã..
·½·¨¶þ:
Ö±½Ó´ÓAccessÉýǨµ½MSsql..
ÒòΪAccessÊý¾Ý¿âÓÐÉèÖÃÃÜÂë..»¹Õæ²»ºÃ¸ã..¸ãÁ˺ü¸´Î¶¼Ê§°ÜÁË..
ÀûÓ÷½·¨¶þ..Ò»´Î³É¹¦..
ÓÃÊý¾Ý¿âÉýǨ...¼òµ¥...
½¨ÒéʹÓõڶþÖÖ·½·¨µ¼ÈëACCESSÊý¾Ý¿âµ½MSSQLÊý¾Ý¿âÖÐ..Ê¡ÊÂ!!! ......

PHP ²Ù×÷Access (ÕýÈ·)

 µÚÒ»ÖÖ·½·¨£º
<?php
class Access{
    function getConn(){
        $conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
        $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath(__IMP ......

Access Web System from external

Take Equity Collection System as an example, Some other office collegues want to access it from home without VPN, The way to check is:
1.  Check if it's limited in network, this needs to confirm with network people
2.  If the step 1 passed, get the external IP address of the system, map ......

access µÄ¶à¸öleft join Òª¼ÓÀ¨ºÅ

 string sql = "select  a.orderId,a.UserName,b.CodeValue as Delivery ,a.DeliveryAddress,a.PhoneNum,c.CodeValue as Payment,d.CodeValue as OrderStatus,d.CodeValue as OrderStatusID,a.OrderTime,a.Merchant from  (( m_Order a ";
            sql += " left j ......

·¢Ò»¸öǰһ¶Îʱ¼äдµÄС¹¤¾ßVC+Access(¸½Ô´´úÂë)


´ó¸ÅµÄ¹¦ÄܾÍÊÇÈÕÆÚÌáÐÑ£¬°ÑͨѶ¼ºÍÈÕÆÚÌáÐÑÏà½áºÏ¡£
ÌáÐÑ·½Ãæ×öµÄºÜ²î£¬¼¼ÊõÓÐÏÞ¡£
Ƥ·ôÓõÄÊÇSkin++
µÚÒ»´Î·¢£¬µ«Ö®Ç°Ð޸Ĺý¼¸´Î£¬Ä¿Ç°°æ±¾0.7
×öÕâ¸ö¶«Î÷ÍêÈ«ÊÇÒòΪÎÒ¸öÈËÐèÒª¡£
ÊÇÒ»¸ö¶àÓû§µÄ¹¤¾ß¡£
ÓÐ×Ô¶¯Éý¼¶¹¦ÄÜ¡£
Ó¦Ó÷¶Î§ºÜÕ­¡£
ÏÂÔØµØÖ·£ºhttp://www.cppblog.com/Files/pencil/GoodFriendV0.7.rar
Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ