¼ÆËã»úÉϲ»×°ACCESSÊý¾Ý¿â£¬ÈçºÎ´´½¨ACCESSÊý¾Ý¿â
¼ÆËã»úÉϲ»×°ACCESSÊý¾Ý¿â£¬ÈçºÎ´´½¨ACCESSÊý¾Ý¿â£® ´úÂëÈçÏ£º ADOX::_CatalogPtr pCatalog(__uuidof(ADOX::Catalog)); _bstr_t str="Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\\123.mdb"; try { pCatalog->Create(str); //´´½¨Êý¾Ý¿â } catch(_com_error &e) { ::MessageBox(NULL,_T("Êý¾Ý¿â´´½¨Ê§°Ü¡£"), _T("Ìáʾ"),MB_OK | MB_ICONINFORMATION); } CoUninitialize();
ÔÚ×°ºÃACCESSµÄ»úÆ÷ÉÏ´´½¨ºÃ£¬µ±×÷×ÊÔ´´ò°üµ½³ÌÐòÖУ¬ÔËÐеÄʱºòÊͷųöÀ´¡£ÒýÓà ÔÚ×°ºÃACCESSµÄ»úÆ÷ÉÏ´´½¨ºÃ£¬µ±×÷×ÊÔ´´ò°üµ½³ÌÐòÖУ¬ÔËÐеÄʱºòÊͷųöÀ´¡£ Òª´´½¨AccessÊý¾ÝÎļþ£¬¾Í±ØÐëµÃÓÐAccess£¬ ·ñÔò£¬Çɸ¾ÄÑΪÎÞÃ×Ö®´¶¡« ÒýÓà ÒýÓà 1 Â¥ zyq5945 µÄ»Ø¸´: ÔÚ×°ºÃACCESSµÄ»úÆ÷ÉÏ´´½¨ºÃ£¬µ±×÷×ÊÔ´´ò°üµ½³ÌÐòÖУ¬ÔËÐеÄʱºòÊͷųöÀ´¡£ Òª´´½¨AccessÊý¾ÝÎļþ£¬¾Í±ØÐëµÃÓÐAccess£¬ ·ñÔò£¬Çɸ¾ÄÑΪÎÞÃ×Ö®´¶¡« Äã´íÁË£¬¿ÉÒÔÓôúÂëÉú³ÉÒ»¸ö.MDBÎļþ,ËäȻûװACCESS,Ò²¿ÉÒÔ²Ù×÷ ÔÚÓëÄ㿪·¢°æ±¾¶ÔÓ¦µÄVS°²×°°üÀïÃæÕÒµ½Ò»¸ö½Ð MDAC_TYP.exe,Ó¦¸ÃÊǽÐÕâ¸öÎļþÃû£¬Ä¿±ê»úÉϰ²×°ÉϾͿÉÒÔÓᣲ»Ð
Ïà¹ØÎÊ´ð£º
ÒÑÖªÁ½¸öÊý¾Ý¿â£¬·Ö±ðΪBASE.MDB ºÍ BASE2.DBF ×ֶηֱðΪBASE.MDB:NAME NAME2 NAME3 A B C D E F ......
CREATE TABLE Product(model integer, maker varchar(20), CONSTRAINT SAND PRIMARY KEY (model), CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) ON DELETE CASCADE ......
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤? ÄãÊÇÔõÑù¸³ÖµµÄ£¿ ²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÎÒдÁËÒ»¸öÈí¼þ£¬ÒªÓõ½ACCESSÊý¾Ý¿â£¬ÎÒÔÙ·ÃÎÊACCESSµÄʱºò£¬ÎÒÐèÒª´Ó±íÀï¶Á³öÒ»ÐÐÊý¾Ý£¬ÎҵijÌÐòÊÇÕâÑùдµÄ£¬SQLSTRING="SELECT * from '" &ME.TEXTBOX1.TEXT &"' WHERE ID = '"& ......
²éÁ˺ó¤ºÃ³¤Ê±¼ä£¬ÎÊÌâÖÕÓÚ½â¾ö£¬Ï£ÍûÓÐÕâÑùµÄÎÊÌâµÄÅóÓÑÉÙ×ßЩÍä·¡£ ×¢Ò⣬ÎÒÕâÀïʱºòËù˵µÄÊÇÖ»ÓÐÒýÓÃÊý¾Ý¿âµÄÖÐÎÄÂÒÂë£¬Ò³ÃæÆäËûÖÐÎÄÕý³££¬ÆäËûÇé¿öÔò²»Ò»¶¨ÊÊÓᣠÔÚÏÖÊµÒ³Ãæ×î¶¥¶Ë¼ÓÈëÏÂÃæÁ½¾ä£º
......