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)
{
Ïà¹ØÎĵµ£º
Web Server Access on a VirtualBox Guest
In: Computing ÊýÂë±à³Ì
7
Oct
2008
I been using VirtualBox to deploy virtual machines on my Windows
machine since a significant memory upgrade. VirtualBox is suprisingly
easy to used if compared to VMWare and it just fit to my basic needs.
Access the ......
×î½üÕûÀí³öÀ´µÄ.Èç¹û²»ÍêÈ«µÄ»°Ï£Íû´ó¼Ò²¹³ä.
ÔÚaccessÖУ¬×ª»»Îª´óдµÄsqlº¯ÊýÊÇucase£¬ÔÚsqlserverÖУ¬×ª»»Îª´óдµÄº¯ÊýÊÇupper£»ÔÚaccessÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlcase£¬ÔÚsqlserverÖУ¬×ª»»ÎªÐ¡Ð´µÄº¯ÊýÊÇlower£»ÔÚaccessÖУ¬È¡µ±Ç°Ê±¼äµÄº¯ÊýÊÇnow£¬ÁíÍ⻹ÓÐÒ»¸öÈ¡ÈÕÆÚº¯Êýdate£¬ÔÚsqlserverÖУ¬È¡µ±Ç°µÄº¯ÊýÊÇgetdate ......
ËäÈ»Firebird×ÜÌåÉÏÊDZÈAccessºÃ£¬µ«ÊÇûÓд«ËµµÄÄÇôºÃ£¬ÖÁÉÙÔÚNet»·¾³Ï¡£
1¡¢²âÊÔ»·¾³
¡¡¡¡A¡¢ÏµÍ³»·¾³
¡¡¡¡²Ù×÷ϵͳ£ºWindows XP Professional Server Pack 2
¡¡¡¡CPU£ºIntel(R) Pentium(R) 4 CPU 3.00GHZ 2.99GHZ
¡¡¡¡Äڴ棺1G
¡¡¡¡B¡¢´úÂë»·¾³
¡¡¡¡NET2.0¡¢Access2003¡¢Firebird2.1¡¢
¡¡¡¡FirebirdµÄNET2.0· ......
accessÖÐcaseÌæ´ú·½·¨
2009-12-26 14:01
SELECT
UserPassportID as PassportID,
UserID,
GrantorID,
Case ObjectTypeID
When 1 then ObjectID
End
as TerminalID,
Type, Flag, GrantDate, Validate, Invalidate
from UserPassport
ÔÚSQLÀïÄÜÖ´ÐÐ,µ«ÔÚAccessÀï×ÜÌáʾÓï·¨´íÎó(²Ù×÷·û¶ªÊ§).ÔÚ²éѯ±í´ïʽ'Case O ......
¼ò½é
ÔÚÔçÆÚ°æ±¾µÄ Microsoft® Access£¨Microsoft Access 2000 ÒÔǰ£©ÖУ¬Óйذ²È«ÐÔµÄ֪ʶÓÐʱ±»ÈÏΪÊÇÎÞ·¨ÎªÈκÎÈËËùÕÆÎÕºÍÓ¦Óõġ£ÄúÐèÒª°´Ë³ÐòÖ´ÐкܶಽÖ裬һµ©ÒÅ©ij¸ö²½Öè»òÕߵߵ¹ÁË˳Ðò¾Í»á´øÀ´ÔÖÄÑÐԵĺó¹û¡£Ëæ×Å Microsoft Access for Microsoft Windows® 95 µÄ Security Wizard ³öÏÖ£¬ÒÔ¼° Microsoft ......