Ò»¸ö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 ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÈçÌâÔÚÎÒ´ò¿ªaccessÐ޸ĵÄʱºò±¨´í
ÎÒ×°µÄGhost µÄXP°æ sp3µÄ²¹¶¡
´íÎóÇ©Ãû
AppName: msaccess.exe AppVer: 11.0.8166.0 AppStamp:46437912
ModName: pintlgnt.ime&n ......
±ÈÈçÏë°Ñ old¸Ä³É new£¬ÔõÃ´Ð´ÄØ£¿
²»ÄÜ£¬ÓÃADO¡¡OR¡¡DAO
or
select * into new from old
£¬ÓÃADO¡¡Õâ¸öÔõô¸Ä£¿
JET-SQL²»ÄܸıíÃû¡£Ö»ÄÜÉú³ÉÒ»¸öеġ£
Ò»°ãÊÇÖ±½Ó
SQL code:
select * ......