AccessÊý¾Ý±í×Ö¶ÎÀàÐÍ´óÈ«
½ñÌìÔÚÓÃC#´´½¨AccessÊý¾Ý¿âµÄʱºòÓöµ½ÁËÒ»¸ö×Ö¶ÎÀàÐ͵ÄÎÊÌ⣬ÒòΪ³ÌÐò´´½¨Êý¾Ý¿â±íÕâ¸öÔÚSqlServerÉϱȽϳ£¼û£¬ÔÚ°Ù¶ÈÖÐÕÒÁ˺ܾ㬰ÑÏà¹ØµÄÊôÐԳ¼ÏÂÀ´°É£¬ÒÔ¹©ÒÔºóʹÓá£
1¡¢¶¯Ì¬´´½¨AccessÊý¾Ý¿â£º±¾È˾õµÃÓÃADOXµÄ·½Ê½¼òµ¥ÊǼòµ¥£¬µ«ÊÇ»¹ÊÇÐèÒªÒ»¸öDLL×齨·½¿ÉÒÔʵÏÖÊý¾Ý¿âµÄ´´½¨£¬ËùÒÔÄÇÎÒÃǾͻ»¸ö˼·°É£¬ÎªÊ²Ã´²»¿ÉÒÔÕâÑùÀ´ÄØ¡£´´½¨Ò»¸ö¿Õ°×µÄÊý¾Ý¿â£¬Ö®ºóͨ¹ý³ÌÐòÈ¥´´½¨Êý¾Ý¿âµÄ±í£¬ÕâÑùµÄЧ¹û²»ÊÇÒ²¿ÉÒÔʵÏֵģ¿
2¡¢¶¯Ì¬´´½¨AccessÊý¾Ý¿â±í£ºCreate Table Admin (ID INT,UserName VarChar(50),UserPass VarChar(50))£¬ÕâÀïÓöµ½ÁË×Ö¶ÎÊôÐÔµÄÎÊÌ⣬¾ßÌåµÄÊôÐÔÖµÇë¿´ÏÂÃæµÄ±í°É¡£
----------------------------------------------------------------------------
ÀàÐÍÃû³Æ TYPE ±¸×¢
----------------------------------------------------------------------------
×Ô¶¯±àºÅ integer + identity(1,1)
Îı¾ varchar(50) À¨ºÅÖеÄÊý×ÖΪÎı¾³¤¶È
³¤ÕûÐÍ integer
ÕûÐÍ short
Ë«¾«¶ÈÐÍ double,float
µ¥¾«¶ÈÐÍ real
×Ö½ÚÐÍ byte
СÊý NUMERIC(6,2)
»õ±Ò money
±¸×¢ text
ÈÕÆÚ/ʱ¼ä &nb
Ïà¹ØÎĵµ£º
ÔÚSQL Server ÄÚ²éѯAccess Êý¾Ý, ²¢½«Êý¾Ý±£´æµ½SQL Server
-- OPENROWSET ACCESS ²»ÄÜÓÐÃÜÂë, ÓÐÃÜÂëÓÃOPENDATASOURCE
SELECT *
from OPENROWSET ('Microsoft.Jet.OLEDB.4.0',
'C:\temp\Test.mdb'; /*Access Êý¾Ý¿â·¾¶*/
'admin'; /*Access¹¤×÷×éÃÜÂë*/
'',/*Access¹¤×÷×éÃÜÂë*/
[AccessTableName])
1. ²éѯAcce ......
±¾ÎĽéÉÜjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨¡£Õâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ¬ÔÚÏßÔòÐèÒª×ã¹»µÄȨÏÞ¡£ÓÉÓÚ²ÉÓÃAccessÊý¾Ý¿â£¬ËùÒÔ²¢²»Ê¹Óñê×¼µÄSQLÓ﷨ʹÓÃʱ¡£ÐèҪעÒâ¡£
Õ⼸Ìì·ÑÁËͦ´óÁ¦ÆøÔÚÍøÉϲéÕÒjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨£¬¾¹ýÕûÀí×ܽᣬÖÕÓÚд³öÒ»¶ÎÄܹ»ÓÐЧִÐеĴúÂë¡£
µ«ÊÇÕâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ ......
Access±£Áô×Ö&±äÁ¿ÃûÁÐ±í£¬½¨±íʱӦ±ÜÃâʹÓÃÕâЩ´Ê»ãºÍ·ûºÅ¡£
-A
ADD
ALL
Alphanumeric
ALTER
AND
ANY
Application
AS
ASC
Assistant
AUTOINCREMENT
Avg
-B
BETWEEN
BINARY
BIT
BOOLEAN
BY
BYTE
-C
CHAR, CHARACTER
COLUMN
CompactDatabase
CONSTRAINT
Container
Count
COUNTER
CREATE
C ......
Access¡¢HybridºÍTrunkÈýÖÖģʽµÄÀí½â
Ô¤±¸ÖªÊ¶£º
Tag£¬untagÒÔ¼°½»»»»úµÄ¸÷Öֶ˿ÚģʽÊÇÍøÂ繤³Ì¼¼ÊõÈËÔ±µ÷ÊÔ½»»»»úʱ½Ó´¥×î¶àµÄ¸ÅÄîÁË£¬È»¶ø±ÊÕß·¢ÏÖÔÚʵ¼Ê¹¤×÷Öм¼ÊõÈËÔ±ÍùÍù¶ÔÕâЩ¸ÅÄîËƶ®·Ç¶®£¬±ÊÕ߸ù¾Ý×Ô¼ºµÄÀí½âÔÙ½áºÏÒ»¸ö°¸Àý£¬ÊÔͼÏò´ó¼Ò²ûÃ÷ÕâЩ¸ÅÄî
untag¾ÍÊÇÆÕͨµÄethernet±¨ÎÄ£¬ÆÕͨPC»úµÄÍø¿¨ÊÇ¿ÉÒÔʶ±ðÕâ ......
1.´´½¨ Access Êý¾Ý¿â£¬²¢¹Ø±ÕÆäÁ¬½Ó
Access ²Ù×÷µÄÁ½¸öÒýÓÃ:
1) Microsoft ActiveX Data Objects 2.8 Library
2) Microsoft ADO Ext. 2.8 for DDL and Security
/// <summary>
/// ´´½¨Êý¾Ý¿â²¢·µ»ØÁ¬½Ó×Ö·û´®
/// </summary>
/// <param name="dbName">·¾¶+Îļþ ......