VB6+ACCESS2003+ADO¿ª·¢µÄÒ»¸ö³ÌÐò£¬¿Í»§ÔËÐÐʱ£¬Òì³£Í˳ö£¬ACCESS´¦ÓÚËø¶¨×´Ì¬£¬ÈçºÎÈóÌÐòÔÙ´ÎÔËÐÐʱ£¬¼ì²âACCESSµÄËø¶¨×´Ì¬£¬²¢È¥ÏûACCESSµÄËø¶¨×´Ì¬£¬±£Ö¤³ÌÐòµÄÕý³£ÔËÐС£
¶¥ÏÈ.
´ò¿ªµÄʱºòÓ¦¸Ã»áÓÐÒ»¸öLDBÎļþÉú³É,Ö»Òª¼ì²âÓÐûÓÐ,ÓоÍɾ³ý,Ó¦¸Ã¾Í¿ÉÒÔÁË
Èç¹ûÊǵ¥»ú°æ³ÌÐò,¿ÉÒÔ°´3Â¥»ò2Â¥Òâ¼û°ì.
ÈÎÎñ¹ÜÀ ......
ÔÚACCESSÖУ¬Ïë°ÑÏÂÃæ¶¼Ð¡ÊýÓðٷֱȱíʾ£¬µ«°´Å¥Êǻҵģ¬Ê²Ã´Çé¿öϲſÉÒÔÓã¿£¿
http://club.excelhome.net/viewthread.php?tid=484552&extra=page%3D1&frombbs=1
ͼƬµØÖ·
ÄãÓõÄÊÇ2007°É£¬Ö±½ÓÔÚ´úÂëÖÐÉèÖò»ÐУ¿
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
......
vc ADO µôÓà access×Ô¼ºÉè¼ÆºÃµÄ²éѯ
¸÷λ´óÏÀÓÐ×ö¹ýÕâ·½ÃæµÄô?°ïæÌáÐÑÒ»ÏÂ,лл~
¸úµ÷ÓñíÒ»Ñù¡£
²»ÊǰÉ?Ôõôµ÷Óñí?
select * from lhz where id = :a
¼ÙÈçÕâ¸öÊDzéѯÓï¾ä,±íÃûÊÇlhz,°ÑÏëÕҵĶ«Î÷ÉèÖÃΪa .
Ôõôµô?
ÄѵÀ _Recordset Rs = Open(_vaiant_t(select * from lhz where id = :a ).... ......
DAO,ÈçºÎ¸ü¸ÄAccessÊý¾Ý¿âµÄ±íÃû?
DAOÊDz»Ðеģ¬Ì«ÀÏÁË¡£ADOX¿ÉÒÔ
MFCµÄDAO·â×°À಻֧³Ö¡£ÐèÒªÖ±½Óµ÷ÓÃDAO SDK»òÕßADOX¡£
ʹÓÃADOX
ÎÒÕâÑù¸ÄµÄ...Ã²ËÆ³É¹¦ÁË...
C/C++ code:
CDaoDatabase m_DaoDB;
m_DaoDB.Open(szDBFilePath);
CDaoTableDef m_pTableDef(&m_DaoDB);
m_pTableDef.Open(szOldTa ......
datagridviewÖÐÓжàÐÐÊý¾Ý£¬
ÒªÇóɾ³ýaccessÖÐÊý¾Ý.
°ï°ïæ°É£¬
Ñ»·ÓÃÊÂÎñ³ÉÅúµ¼Èë.
¸ø´úÂë°É
C# code:
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.mdb;Jet OLEDB:Database Password=");
con.Open();
......
ÈçºÎÔÚoffice2007ÖÐÉèÖÃÁ¬½ÓÊý¾Ý¿âaccessµÄÃÜÂ룿
ÈçºÎ²Ù×÷£¬ÇëÈËÖ¸µãһϣ¬×îºÃÏêϸһµã
ÈËÄØ£¿
ÏÈ´ò¿ªAccess£¬ÓÒÉϽǵã´ò¿ª£¬ÕÒµ½ÒªÉèÖõÄÊý¾Ý¿â£¬ÏÂÃæÑ¡ÔñÒÔÖ»¶Á·½Ê½´ò¿ª£¬
Êý¾Ý¿â¹¤¾ß -ÓÃÃÜÂë½øÐмÓÃÜ
Á¬½Ó£ºC# code:
string strConn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Jet ......