Access 2007 ÔõôÉèÖ÷ÀÖ¹Ð޸ģ¿
ÎÒµÄÏîÄ¿µÄ¼¸¸öÖØÒªµÄ±í·ÅÔÚÕâ¸öAccessÀï¡£Õ⼸¸ö±íÖ»¶ÁµÄ²»ÐèÒªÐ޸ġ£ÇëÎÊÓÐʲô·½·¨½ûÖ¹·¢ÉúÐÞ¸ÄÄØ£¿ÎÒÒª±£Ö¤Êý¾ÝµÄÍêÕûÐÔ¡£
2003 ÖпÉÒÔ½øÐÐÓû§×éµÄȨÏÞµÄÉèÖá£
ÎÒÖ»ÏëÒª2007µÄ¡£ÒòΪÃÜÂ뻹ûÓÐÈËÄÜÆƽâ³ö
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
string strAdd = "update tb_Note set Note='" + richTextBox1.Text + "' where NoteCode='"+strflag +"'"
¶¼ÊÇÎı¾ÀàÐ͵Ä
ÍêÈ«ÕýÈ·¡£
Äã²»ÊÔһϾÍÌá¸ß
......
¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º
£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ
......
SQL code:
select count(1) from HouseList a left join MemberList b on
(a.OperationName=b.UName and a.Eid=1 and a.houselc='2')
ÒÔÉÏÕâÌõÓï¾äÔÚsql2005ÖвéѯµÃµ½760Ìõ¼Ç¼,·ÅÔÚaccessÖвéѯֻÓÐ14Ì ......
ÎÒÏÖÔÚaccess±íÖÐijһ×Ö¶ÎA ÓÐÏÂÃæµÄÄÚÈÝ(Ö»ÊǺóÃæµÄ²¿·Ö²»Ïàͬ)
1.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=ËûºÍËýµÄÄ ......