ÏÖÔÚ×î³£ÓõÄaccessÎļþ¼ÓÃÜ·½·¨ÊÇʲô£¿
ÎÒ×öµÄϵͳÖÐÓõ½ÁËaccessÊý¾Ý¿â£¬ÏÖÔÚ½«ÏµÍ³·¢²¼µ½¿Í»§¶Ëºó£¬²»Ï£Íû¿Í»§ÄÜÖ±½ÓÓÃaccessÈ¥´ò¿ªÕâЩmdbÎļþ×ö²éѯ»òÐ޸ġ£ ÇëÎÊ×î·½±ãµÄ¼ÓÃÜmdb·½·¨ÊÇʲô£¿ лл£¡
ÒýÓà һ°ãǰ̨MDE OR ÓïÑÔEXE£¬ºǫ́MDB ллlsµÄ»Ø´ð¡£ÎÒÕâ¸öϵͳÊǵ¥»ú°æµÄ¡£°ÑËùÓÐÎļþ´ò°ü¸ø¿Í»§¡£ ÉÏÃæÄã˵µÄÕâ¶Î»°²»Ì«Ã÷°×ʲôÒâ˼¡£ÎÒÕâ¸öÊǵ¥»úµÄ£¬ºÃÏñûÓÐǰºǫ֮́·Ö¡£ »òÕßaccessÓмÓÃÜÂëµÄ·½·¨Âð£¿ÎÒ¸ømdbÎļþ¼Ó¸öÃÜÂë¡£ÄÜÆÆ½âµ¹Ò²ÎÞËùν¡£ Access °²È«¸ÅÊö (MDB) ×¢ÊÍ ±¾Ö÷ÌâÖеÄÐÅÏ¢½öÊÊÓÃÓÚ Microsoft Access Êý¾Ý¿â (.mdb)¡£ Óи÷ÖÖ²»Í¬µÄ²ßÂÔÓÃÀ´¿ØÖÆ¶Ô Microsoft Access Êý¾Ý¿â¼°Æä¶ÔÏóµÄ·ÃÎʼ¶±ð¡£ÏÂÃæ´óÖ°´ÕÕ°²È«¼¶±ðµÄ˳Ðò£¬¼òÒª½éÉÜÕâЩ²ßÂÔ¡£ ±àÂë/½âÂë ΪÊý¾Ý¿â±àÂëÊÇ×î¼òµ¥µÄ±£»¤·½·¨¡£ÎªÊý¾Ý¿â±àÂë¿ÉѹËõÊý¾Ý¿âÎļþ£¬²¢°ïÖú·ÀÖ¹¸ÃÎļþ±»ÎÄ×Ö´¦Àí³ÌÐò¶ÁÈ¡¡£µ«¶Ôδʵʩ°²È«´ëÊ©µÄÊý¾Ý¿â½øÐбàÂ뽫ÊÇÎÞЧµÄ£¬ÒòΪÈκÎÈ˶¼¿É´ò¿ªÕâÖÖÊý¾Ý¿â²¢ÇÒ¶ÔÊý¾Ý¿âÖеĶÔÏóÓµÓÐÍêÈ«·ÃÎÊȨ¡£µ±Óõç×Ó·½Ê½´«ÊäÊý¾Ý¿â»òÕß½«Êý¾Ý¿â´æ´¢ÔÚÈíÅÌ¡¢´Å´ø»ò¹âÅÌÖÐʱ£¬½øÐбàÂëÓÈΪÓÐÓᣠֻÓзûºÏÒÔÏÂÌõ¼þ£¬²ÅÄÜΪ Microsoft Access Êý¾Ý¿â½øÐбàÂë»ò½âÂ룺Äú±ØÐëÊǸÃÊý¾Ý¿âµÄËùÓÐÕߣ»»òÕߣ¬Èç¹ûÊý¾Ý¿â²ÉÈ¡Á˰²È«´ëÊ©£¬Ôò±ØÐëÊǹ¤×÷×éÐÅÏ¢Îļþ£¨°üº¬ÓÃÓÚ°ïÖú±£»¤Êý¾Ý¿âµÄÕÊ»§£©µÄ¹ÜÀíÔ±×é³ÉÔ±£»Äú»¹±ØÐëÄܹ»ÒÔ¶Àռģʽ´ò¿ªÊý¾Ý¿â£¬Ò²¾ÍÊÇ˵±ØÐëÓµÓС°´ò¿ª/ÔËÐС±ºÍ¡°ÒÔ¶ÀÕ¼·½Ê½´ò¿ª¡±µÄȨÏÞ¡£ Êý¾Ý¿â½âÂëÊDZàÂëµÄÄæ¹ý³Ì¡£ ÔÚ¡°Êý¾Ý¿â¡±´°¿ÚÖÐÏÔʾ»òÒþ²Ø¶ÔÏó ÁíÍâÒ»ÖÖ±£»¤Êý¾Ý¿â¶ÔÏóÃâÊÜżȻ·ÃÎÊÓû§ÆÆ»µµ
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
CREATE TABLE Product(model integer, maker varchar(20), CONSTRAINT SAND PRIMARY KEY (model), CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) ON DELETE CASCADE ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬ http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
¸÷λ¸ßÊֺã¬Âé·³°ïÎÒ¿´ÏÂÕâ¸öÊý¾Ý¿âÁ¬½ÓÎÊÌ⣺ ×öÁËÒ»¸öBBSµ«ÊÇÊý¾Ý¿â¾ÍÊÇÁ¬½Ó²»ÉÏ¡£´íÎó´úÂëÈçÏ HTTP Status 500 - ------------------------------------------------------------------------------- ......
ÎҵijÌÐòÈçÏ£º Dim Cnn As New ADODB.Connection Dim Rs As New ADODB.Recordset Dim myData As String, myTable As String Dim myFields As Variant, myValue As Var ......