Ò»¸ö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Ù×÷ϵͳµÄÎÊÌ⣬ÄǾͲ»ÒªÈ¥×êÕâ¶«¶«
Ïà¹ØÎÊ´ð£º
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÔÚ¿Í»§¶ËÓиöaccessÊý¾Ý¿âa.mdb£¬ÀïÃæÓÐÕűítb1£¬Óжþ¸ö×Ö¶ÎÁ÷Ë®ºÅºÍ»ý·Ö
ÔÚ¾ÖÓòÍøÀïÓиö·þÎñÆ÷ipÊÇ192.168.1.88£¬ÔÚ·þÎñÆ÷Àï×°ÁËsql2000£¬ÀïÃæÒ²ÓÐÒ»Õűíaa£¬aa±íÀïÓжþ¸ö×ֶηֱðÊÇb1ºÍb2¡£Êý¾Ý¿âÃûÊÇyy,
......
ÇëÎÊÈçºÎ»ñȡָ¶¨±íµÄ×ֶθöÊý£¿
ÓеÄÊý¾Ý¿âÓÐϵͳ±í£¬¿ÉÒԲ鵽£¬²»Í¬µÄÊý¾Ý¿âÓв»Í¬·½·¨
¸øÄãÒ»¸ö¼òµ¥·½·¨£¬´Ó¼Ç¼¼¯»ñÈ¡
rs.Fields.Count
ÒýÓÃ
ÓеÄÊý¾Ý¿âÓÐϵͳ±í£¬¿ÉÒԲ鵽£¬²»Í¬µÄÊý¾Ý¿âÓ ......