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

accessÌí¼ÓÊý¾Ý

sql="insert  into  users(username,password) values('aa','bbb')" 
conn.execute sql
²¹³ä£ºÔõô¼Ó²»½øÈ¥ÄØ£¿


ÒòΪaa,bbbÊÇÄã×Ô¼º¶¨ÒåµÄ±äÁ¿£¬Ëùд³ÉÕâÑù²Å¿ÉÒÔ

´íÁË~ÎÒ¾ÍÊÇÏë¼ÓÈë Óû§Îªaa£¬ÃÜÂëΪbbbµÄ  ²»ÊǶ¨ÒåµÄ±äÁ¿

¸Ä³ÉÕâ¸öºósql="insert  into  users(username,[password]) values('aa','bbb')" 
conn.execute sql
ÓÖ±ä³ÉÕâ¸ö´íÎ󣺲Ù×÷±ØÐëʹÓÃÒ»¸ö¿É¸üеIJéѯ¡£0x80004005

½â¾ö xpȨÏÞÎÊÌâ
´ò¿ªÈÎÒâÒ»¸öÎļþĿ¼£¬µã»÷¡°¹¤¾ß¡±->¡°Îļþ¼ÐÑ¡Ï->¡°²é¿´¡±£¬ÕÒµ½¡°Ê¹Óüòµ¥Îļþ¹²Ïí£¨ÍƼö£©¡±ÕâÏ°ÑÇ°ÃæµÄ¹´È¥µô¡£
ÔÚÍøÕ¾ËùÔÚÎļþ¼ÐÉϵ¥»÷ÓÒ¼ü£¬Ñ¡Ôñ¡°ÊôÐÔ¡±£¬Õâʱ¾ÍÄÜÕÒµ½¡°°²È«¡±µÄÑ¡Ï£¬Ìí¼ÓÒ»¸öÓû§Everyone£¬È¨ÏÞÉèΪ¡°ÍêÈ«¿ØÖÆ¡±£¬ÕâÑùÈκÎÈ˶¼¶ÔÄãµÄÍøվĿ¼ÓжÁдȨÏÞÁË£¬ÎÊÌâµÃÒÔ½â¾ö
±¾ÎÄתժ×Ô¡ºITѧϰÕß¡»http://www.itlearner.com/article/2006/3282.shtml


Ïà¹ØÎÊ´ð£º

ͬʱ¶ÁÈ¡accessÁ½Õűí

Çë½Ì
ÔÚaccessÖÐ ÎÒÓбí1
id1    id2      id3      id4
  1      2      3        0
  2&nb ......

ÈçºÎͨ¹ýADOʹÓþۺϺ¯ÊýÀ´²éѯ(Êý¾Ý¿âΪACCESS)

_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
    int ret = 0;
  _RecordsetPtr pset;
CString  sql;
& ......

¹úÇì½ÚÒ»ÎÊ: ÈçºÎÅúÁ¿¸üÐÂAccessÖÐ×ֶβ¿·ÖÄÚÈÝ?

ÎÒÏÖÔÚaccess±íÖÐijһ×Ö¶ÎA ÓÐÏÂÃæµÄÄÚÈÝ(Ö»ÊǺóÃæµÄ²¿·Ö²»Ïàͬ)

1.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=ËûºÍËýµÄÄ ......

Access導³öExecl

VB+Access×öµÄϵ統£¬
為·½±ã²é閱與´òÓ¡£¬
Ðè導³ö為execl±í¸ñ£¬
help¡£
環¾³£ºAccess±íÊÇAccess 2000£»

ÍøÉϺܶà,°Ù¶ÈÒ»ÏÂ

¹Ø×¢£¡

´°Ìå´úÂë
VB ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ