Access ²Ù×÷ѧϰ¼Ç¼
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">·¾¶+ÎļþÃû</param>
/// <returns></returns>
public static bool CreateAccess(string dbName)
{
try
{
string databaseConn;
//dbName = @"d:\newAccess.mdb";
databaseConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbName + ";";
if (File.Exists(dbName)) return false;
// ´´½¨Êý¾Ý¿â
ADOX.CatalogClass accessCatalog = new CatalogClass();
accessCatalog.Create(databaseConn);
#region
//// ´´½¨Ò»¸ö±í
//ADOX.TableClass table = new ADOX.TableClass();
//table.ParentCatalog = accessCatalog;
//table.Name = "MyTable";
//// ´´½¨Ò»¸ö×Ô¶¯Ôö³¤×Ö¶Î
//ADOX.ColumnClass col = new ADOX.ColumnClass();
//col.ParentCatalog = accessCatalog;
//col.Type = ADOX.DataTypeEnum.adInteger;//ÉèÖÃ×Ö¶ÎÀàÐÍ
//col.Name = "ID";
//col.Properties["jet OLEDB:Allow Zero Length"].Value = false;
//col.Properties["AutoIncrement"].Value = true;
//table.Columns.Append(col,ADOX.DataTypeEnum.adInteger,0);
//// Ìí¼Ó±í
//accessCatalog.Tables.Append(table);
#endregion
/*
* ¹Ø±ÕÊý¾Ý¿âÁ¬½Ó£¬±ØÐëͨ¹ý ADODB À´ÊµÏÖ£¬·ñÔò´´½¨µÄÊý¾Ý¿âÎÞ·¨É¾³ý
*/
ADODB.Connection connection = accessCatalog.ActiveConnection as ADODB.Connection;
if (connection != null)
{
Ïà¹ØÎĵµ£º
Technorati ±êÇ©: VC,ListCtrl ÔÎĵØÖ·£ºhttp://www.vckbase.com/document/viewdoc/?id=1274 ADO²Ù×÷accessÈ«¹ý³ÌºÍCListCtrlµÄÓ÷¨
×÷ÕߣºÕÅÕ¹Ã÷ ÏÂÔØÔ´´úÂë
Ò»¸öADOºÍCListµÄʾÀý³ÌÐò£¨³ÌÐòÖеÄtele.log¼´ÎªaccessÎļþ£¬¿ÉÒÔÖ±½Ó¸ü¸ÄÀ©Õ¹Ãûºó´ò¿ª£©:
ʹÓÃADO²Ù×÷accessÊý¾Ý¿â.Ôö¼Ó,ɾ³ý,ÐÞ¸Ä,²éѯ ......
import java.sql.*;
public class ConnectAccess {
/**
* ³õѧÕßÇë×¢Ò⣺
* 1:ÏȽ¨Á¢Ò»¸öaccessÎļþa1.mdb,²¢·ÅÔÚD:\ÏÂ;
* 2:ÔÚÊý¾Ý¿âÎļþa1.mdbÖн¨Á¢Ò»¸ö±íTable1£»
* 3£ºÎªTable1Ìí¼ÓÒ»ÁУ¬²¢²åÈëÖÁÉÙÒ»Ìõ¼Ç¼£»
* 4£º±¾ÎÄÊÇÒ»¸öÍêÕûµÄÀֱ࣬½ÓÄÃÈ¥ÔËÐоͿÉÒÔ¡£
*/
public static void main(Stri ......
'excelµ¼Èëaccess ,ÒýÓÃADO
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
On Error Resume Next
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source ......
±¾ÎĽéÉÜjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨¡£Õâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ¬ÔÚÏßÔòÐèÒª×ã¹»µÄȨÏÞ¡£ÓÉÓÚ²ÉÓÃAccessÊý¾Ý¿â£¬ËùÒÔ²¢²»Ê¹Óñê×¼µÄSQLÓ﷨ʹÓÃʱ¡£ÐèҪעÒâ¡£
Õ⼸Ìì·ÑÁËͦ´óÁ¦ÆøÔÚÍøÉϲéÕÒjavascriptÁ¬½ÓaccessÊý¾Ý¿âµÄ·½·¨£¬¾¹ýÕûÀí×ܽᣬÖÕÓÚд³öÒ»¶ÎÄܹ»ÓÐЧִÐеĴúÂë¡£
µ«ÊÇÕâ¶Î´úÂëÔÚ±¾µØ¿ÉÒÔÕý³£ÔËÐУ ......
¼ò½é
ÔÚÔçÆÚ°æ±¾µÄ Microsoft® Access£¨Microsoft Access 2000 ÒÔǰ£©ÖУ¬Óйذ²È«ÐÔµÄ֪ʶÓÐʱ±»ÈÏΪÊÇÎÞ·¨ÎªÈκÎÈËËùÕÆÎÕºÍÓ¦Óõġ£ÄúÐèÒª°´Ë³ÐòÖ´ÐкܶಽÖ裬һµ©ÒÅ©ij¸ö²½Öè»òÕߵߵ¹ÁË˳Ðò¾Í»á´øÀ´ÔÖÄÑÐԵĺó¹û¡£Ëæ×Å Microsoft Access for Microsoft Windows® 95 µÄ Security Wizard ³öÏÖ£¬ÒÔ¼° Microsoft ......