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

ACCESS¼ÓÃÜ·½·¨


MicrosoftµÄACCESSÊý¾Ý¿â£¬ÊÇÎÒÃdz£ÓõÄ×ÀÃæÊý¾ÝÖ®Ò»£¬´ó¶àÖÐСÆóÒµµÄÊý¾Ý¿â¹ÜÀíϵͳ¶¼¿ÉÒÔ²ÉÓÃËü£¬µ«Æä°²È«ÐÔÒ»Ö±ÁîÈ˵£ÓÌ£¬ÊÔÏ룬һÌײÆÎñ¹ÜÀíϵͳ£¬Óû§Ö±½Ó´ò¿ªÊý¾Ý¿âÈ¥¸ü¸ÄÊý¾Ý£¬ºó¹û»áÈçºÎ£¿ÓÐЩϵͳ¶ÔACCESSÊý¾Ý¿â¿ÉÄÜÖ»ÊǸü¸ÄÀ©Õ¹Ãû£¬»ò¼Ó¸öÃÜÂ룬ÖÚËùÖÜÖª£¬ÆÆ½âACCESSÃÜÂëµÄ·½·¨ºÍ¹¤¾ßÍøÉ϶àµÄÊÇ£¡ËùÒÔÕâÑùµÄ¼ÓÃÜÒ»ÑùÁîÈ˵£ÓÌ£¬ÏÂÃæ½éÉÜÒ»¸ö¼òµ¥µÄ·½·¨£¬ÊµÏÖACCESSÊý¾ÝµÄ¼ÓÃÜ£¬¹©´ó¼Ò²Î¿¼¡£
    ÓÃUltraEdit´ò¿ªMDBÎļþ¿ÉÒÔ¿´µ½£¬Îļþǰ16¸ö×Ö½ÚµÄÄÚÈÝ£º
00 01 00 00 53 74 61 6E 64 61 72 64 20 4A 65 74
ÏÖÔÚËæ±ã¸ü¸Ä¼¸¸ö£¬ÔÙÓÃACCESS´ò¿ª£¬·¢ÏÖ³öÏÖ²»Í¬Ê¶±ðµÄÎļþ¸ñʽ´íÎó£¬ÒòΪACCESSÇ°Ãæ±£´æµÄÐÅÏ¢¶¼ÊÇһЩMDBÎļþµÄ¶¨ÒåºÍ¿ÚÁÈç¹û¸ü¸ÄÕâЩÄÚÈÝ£¬±ðÈ˾ͺÜÄÑ¿´³öÕâ¸öÊý¾Ý¿âµÄ¸ñʽ£¬ÎÞ·¨´ò¿ªËüÁË£¬¶øÇÒÕâÑù²»»á¶ÔÊý¾Ý¿âµÄÄÚÈÝ×÷¸ü¸Ä£¬²»»áÆÆ»µÔ­ÓеÄÊý¾Ý¡£
ÏÂÃæ¾ÍÓÃDelphi×÷¸ö¼òµ¥µÄ¼ÓÃܽâ³ÌÐò£º
Óõ½µÄ¼ÓÃܽ⺯ÊýÈçÏ£º
const
titlestr:array[0..15] of byte=
($00,$01,$00,$00,$53,$74,$61,$6E,$64,$61,$72,$64,$20,$4A,$65,$74) ;//¶ÔÓ¦MDBÎļþµÄǰ16¸ö×Ö½Ú
titlestr2:array[0..15] of byte=
($48,$4A,$00,$58,$55,$43,$48,$41,$4E,$47,$59,$4F,$55,$00,$20,$20) ;//¸ü¸ÄºóµÄMDBÎļþµÄǰ16¸ö×Ö½Ú£¬×Ô¼ºËæ±ãд°É£¬±ÈÈçдÉÏ×Ô¼º¹«Ë¾µÄ¼ò³Æ»ò×ÔÒѵÄÃû
produce EncrypMDB(filename:string); //ÓÃtitlestr2ÄÚÈÝÌæ»»MDBǰ16¸ö×Ö½Ú£¬ÒÔ±ãʵÏÖ¼ÓÃܵÄ×÷ÓÃ
var F:TFileStream;
begin
    if not fileExists(filename) then   exit;
    F:=TFileStream.create(filename,fmopenwrite);
    try
        F.seek($00,sofromBeginning);
        F.Write(titlestr2,16);
    finally
        F.free;
    end;
end;
produce uncrypMDB(filename:string); //»¹Ô­MDBǰ16¸ö×Ö½Ú
var F:TFileStream;
begin
    if not fileExists(filename) then   exit;
    F:=TFileStream.create(filename,fmopenwrite);
    try
        F.seek($00,sofromBeginning);
  


Ïà¹ØÎĵµ£º

SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......

macÀí½âMedia Access Control½éÖÊ·ÃÎÊ¿ØÖÆ

 Ã½Ìå½ÓÈë¿ØÖÆ²ãµÄËõд
ʲôÊÇmac!!!
Èç¹ûÄãÊÇͨ¹ýÐ£Ô°Íø»òÐ¡Çø½ÓÈëInternet£¬ÄÇôһ¶¨Ìý˵¹ýMACµØÖ·¡£Ê²Ã´ÊÇMACµØÖ·£¬MACµØÖ·ÔÚÕâÖÖ¾ÖÓòÍø»·¾³Öо¿¾¹Æðµ½Ê²Ã´×÷Óã¿ÏÂÃæ¾ÍÀ´½éÉÜÒ»ÏÂMACµØÖ·µÄ֪ʶ£¬MACµØÖ·ºÍIPµØÖ·µÄÇø±ðÒÔ¼°MACµØÖ·ÔÚʵ¼ÊÓ¦ÓÃÖÐËùÉæ¼°µ½µÄ°²È«ÎÊÌâ¡£
¡¡¡¡Ò»¡¢»ù´¡ÖªÊ¶
¡¡¡¡Èç½ñµÄÍøÂçÊÇ·Ö²ãÀ´Êµ ......

ASP.NETµÄACCESSÊý¾Ý¿â²Ù×÷Àà

//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ· 
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ· 
/// 
/// È¡µÃdataset 
// 
/// ²éѯÓï¾ä 
/// 
public DataSet GetDataSet(string Commandtext) 
{&nbs ......

accessº¯Êý²Î¿¼

ÈÕÆÚ/ʱ¼ä
CDate  ½«×Ö·û´®×ª»¯³ÉΪÈÕÆÚ select CDate("2005/4/5")
Date  ·µ»Øµ±Ç°ÈÕÆÚ
DateAdd  ½«Ö¸¶¨ÈÕÆÚ¼ÓÉÏij¸öÈÕÆÚselect dateAdd("d",30,Date())½«µ±Ç°ÈÕÆÚ¼ÓÉÏ30Ìì,ÆäÖÐd¿ÉÒÔ»»Îªyyyy»òHµÈ
DateDiff ÅжÏÁ½¸öÈÕÆÚÖ®¼äµÄ¼ä¸ô select DateDiff("d","2006-5-1& ......

EA2A(Excel/Access to Access)

Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐÆ½Ì¨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔ­ÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼Èë£¨Ç¨ÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ