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

¹ØÓÚ¹²ÏíaccessÊý¾Ý¿âµÄÎÊÌâ

ÎÒÐèҪд¸ö³ÌÐòÔÚB»úÉÏ´ò¿ªAÉϵÄaccessÊý¾Ý¿â£¬¶ÁЩÊý¾Ý£¬ÎÒ°ÑAÉϵÄĿ¼¹²ÏíÁË£¬µ«ÊÇÔÚ¶ÁµÄʱºòÌáʾ˵AÉϵÄÊý¾Ý¿âÕýÒÔ¶ÀÕ¼µÄ·½Ê½´ò¿ª£¬²»³É¹¦¡£ÕâʱºòA¸Õ¿ª»ú£¬AÉϵijÌÐò²¢Ã»Óдò¿ª£¬ÊDz»ÊÇÓÐפÁô½ø³ÌÔÚÓÃAµÄÊý¾Ý¿â£¿Óöµ½ÕâÖÖÇé¿öÎÒ¸ÃÔõô°ì£¿  ÎÒÏ£ÍûÄÜÔÚA»úÆ÷´ò¿ª³ÌÐòµÄʱºò£¬BÒ²ÄܶÁÊý¾Ý¿â£¬ÕâÒªÔõô×ö£¿ лл

ºÃµÄ£¬ÎÒÈ¥¿´Ò»Ï¡£

¼ì²éÒ»ÏÂÄãµÄ³ÌÐòµÄ´ò¿ª·½Ê½£¬ÉèÖÃΪʹÓù²Ïíģʽ´ò¿ª¡£

ÒýÓÃ
ÎÒÐèҪд¸ö³ÌÐòÔÚB»úÉÏ´ò¿ªAÉϵÄaccessÊý¾Ý¿â£¬¶ÁЩÊý¾Ý£¬ÎÒ°ÑAÉϵÄĿ¼¹²ÏíÁË£¬µ«ÊÇÔÚ¶ÁµÄʱºòÌáʾ˵AÉϵÄÊý¾Ý¿âÕýÒÔ¶ÀÕ¼µÄ·½Ê½´ò¿ª£¬²»³É¹¦¡£ÕâʱºòA¸Õ¿ª»ú£¬AÉϵijÌÐò²¢Ã»Óдò¿ª£¬ÊDz»ÊÇÓÐפÁô½ø³ÌÔÚÓÃAµÄÊý¾Ý¿â£¿Óöµ½ÕâÖÖÇé¿öÎÒ¸ÃÔõô°ì£¿   ÎÒÏ£ÍûÄÜÔÚA»úÆ÷´ò¿ª³ÌÐòµÄʱºò£¬BÒ²ÄܶÁÊý¾Ý¿â£¬ÕâÒªÔõô×ö£¿ лл


Èç¹ûÊÇÓÃF/Sģʽ¹²ÓÃMDB£¬ÓÐÕâ¸öÏÖÏ󣬽¨ÒéÓÃADOÁ¬½ÓMDB£¬ÔÙ²Ù×÷


ÎÒÓõľÍÊÇado.netµÄÁ¬½Ó·½Ê½£¬datasetµÄ£¬ÕâÑùÐÐÂ𣿠ʲôÑùµÄ¿ÉÒÔÄØ£¿

Á¬½Ó´úÂëÊÇʲô£¿

OleDbConnection insdb = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=\\\\jiance\\²â¹¦»úϵͳ\\CegongMachine.mdb");
¾ÍÊÇÕâ¸ö  jianceÊÇ»úÆ÷Ãû

ldb ÎļþÊÇ·ñ´æÔÚ£¿ÄÚÈÝÊÇʲô£¿

Ŀ¼¡¢ÎļþÊÇ·ñÓзÃÎÊȨÏÞ£¬¼ì²éÒ»ÏÂ

ÎÒÈ¥¿´ÁËһϣ¬ÀïÃæÃ»ÓÐldbÎļþ£¬ÎÒÓÃaccess´ò¿ª£¬¾ÍÓÐldbÎļþÁË£¬ ÀïÃæÊÇ" jiance  admin ",jiance ÊÇ»úÆ÷Ãû admin ÊÇÄǸö³ÌÐòµÄµÇ¼Ãû¡£

A»úÉϵÄÄǸö³ÌÐò²»ÊÇÎÒ±àµÄ£¬B»úÉϵÄÊÇ£¬ÐèÒªÓÃA»úÉϵÄÊý¾Ý¿â ÒÔǰµ÷ÊÔµÄʱºò¶¼ÊÇÓÿ½¹ýÀ´µÄ¸±±¾£¬ÏÖÔÚµ÷ÊÔµÄʱºò²»ÐÐÁË£¬ËµÊÇ


Ïà¹ØÎÊ´ð£º

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

vb.net ´´½¨accessÊý¾Ý±íʵÏÖÒ»Êý¾Ý¿â¶à¸öÊý¾Ý±í£¿

Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ