ÈçºÎÔÚoffice2007ÖÐÉèÖÃÁ¬½ÓÊý¾Ý¿âaccessµÄÃÜÂ룿
ÈçºÎÔÚoffice2007ÖÐÉèÖÃÁ¬½ÓÊý¾Ý¿âaccessµÄÃÜÂ룿
ÈçºÎ²Ù×÷£¬ÇëÈËÖ¸µãһϣ¬×îºÃÏêϸһµã
ÈËÄØ£¿
ÏÈ´ò¿ªAccess£¬ÓÒÉϽǵã´ò¿ª£¬ÕÒµ½ÒªÉèÖõÄÊý¾Ý¿â£¬ÏÂÃæÑ¡ÔñÒÔÖ»¶Á·½Ê½´ò¿ª£¬
Êý¾Ý¿â¹¤¾ß -ÓÃÃÜÂë½øÐмÓÃÜ
Á¬½Ó£ºC# code:
string strConn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Jet OLEDB:Database Password={1};"
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)
'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......
ÎÊÌâÈçÏ£º
ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º
|/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jp ......
MFCÓÃDAOÁ¬½ÓaccessÊý¾Ý¿â
ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý£¬ÈçºÎŪ£¡£¿
Connection strings for Access
http://www.connectionstrings.com/access
ÒýÓÃ
C/C++ code
_ConnectionPtr m_pConnection;
&n ......