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

Ò»¸öACCESSÊý¾Ý¿â ÄܲåÈ롢ɾ³ý£¬µ«ÊDz»ÄܸüÐÂ

access ÒѽûÓôËÊý¾Ý¿âÖпÉÄÜÓꦵÄÄÚÈÝ vba
ÎÒÓÃaccess´ò¿ªÕâ¸öÊý¾Ý¿âÌáʾ½ûÓÃÁËÕâ¸ö
Èç¹ûÎÒÑ¡ÔñÆôÓà ¾ÍÄܸüÐÂÁË


ÈçºÎÔÚ³ÌÐòÖдò¿ªÊý¾Ý¿âÒ²ÆôÓÃÕâ¸öÄØ£¿

OleDbConnection conn = new OleDbConnection(@"");
  conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath.ToString() + "\\aar.mdb;Persist Security Info=true";
         

UP

Äã°Ñ¸üеĴúÂëÌù³öÀ´  Äã¾ÍÌù¸öÁ´½ÓµÄ´úÂë ¿´²»³öÀ´ ÎÒÓÃACCESSµÄʱºò¶¼Õý³£ ÊDz»ÊÇÄãµÄ´úÂëдµÄÓÐÎÊÌ⣡

ûÓùýaccess

²»ÊǺÜÃ÷°×LZµÄÒâ˼¡£¿ÉÒÔ試ÖøÖ±½ÓʹÓÃSQL語¾ä來¸üÐÂ數據¡£Èç¹ûSQL語¾äÄܸüУ¬ÄÇÄã¾Í±Ø須ºÃºÃ檢²éÄãµÄ¸üдú碼ÁË¡£

ɾ³ýÔÙ²åÈë

²»ÊǺÜÃ÷°×£¬°ïÂ¥Ö÷¶¥£¬µÈ¸ßÊÖ½â¾ö£¡

¶àÊÔ¼¸Ì¨»úÆ÷£¬¿´ÊDz»ÊǶ¼ÓÐÕâÑùµÄÎÊÌ⣬Èç¹ûÖ»ÊǸö±ð»úÆ÷³öÏÖÕâÑùµÄÎÊÌ⣬ÄÇ˵Ã÷ÊDzÙ×÷ϵͳµÄÎÊÌ⣬ÄǾͲ»ÒªÈ¥×êÕâ¶«¶«


Ïà¹ØÎÊ´ð£º

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

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

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......

Äܲ»ÄÜÓÃÒ»ÌõSQLÓï¾ä¸ü¸ÄACCESSµÄ±íÃû£¿

±ÈÈçÏë°Ñ old¸Ä³É new£¬ÔõÃ´Ð´ÄØ£¿
²»ÄÜ£¬ÓÃADO¡¡OR¡¡DAO

or
select * into new from old

£¬ÓÃADO¡¡Õâ¸öÔõô¸Ä£¿

JET-SQL²»ÄܸıíÃû¡£Ö»ÄÜÉú³ÉÒ»¸öеġ£

Ò»°ãÊÇÖ±½Ó

SQL code:
select * ......

Ôõô°Ñ¿Í»§¶ËµÄaccessÊý¾Ý¶¨Ê±¶Áµ½·þÎñÆ÷Àï

ÔÚ¿Í»§¶ËÓиöaccessÊý¾Ý¿âa.mdb£¬ÀïÃæÓÐÕűítb1£¬Óжþ¸ö×Ö¶ÎÁ÷Ë®ºÅºÍ»ý·Ö

ÔÚ¾ÖÓòÍøÀïÓиö·þÎñÆ÷ipÊÇ192.168.1.88£¬ÔÚ·þÎñÆ÷Àï×°ÁËsql2000£¬ÀïÃæÒ²ÓÐÒ»Õűíaa£¬aa±íÀïÓжþ¸ö×ֶηֱðÊÇb1ºÍb2¡£Êý¾Ý¿âÃûÊÇyy, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ