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);
 
Ïà¹ØÎĵµ£º
ýÌå½ÓÈë¿ØÖƲãµÄËõд
ʲôÊÇmac!!!
Èç¹ûÄãÊÇͨ¹ýУ԰Íø»òСÇø½ÓÈëInternet£¬ÄÇôһ¶¨Ìý˵¹ýMACµØÖ·¡£Ê²Ã´ÊÇMACµØÖ·£¬MACµØÖ·ÔÚÕâÖÖ¾ÖÓòÍø»·¾³Öо¿¾¹Æðµ½Ê²Ã´×÷Óã¿ÏÂÃæ¾ÍÀ´½éÉÜÒ»ÏÂMACµØÖ·µÄ֪ʶ£¬MACµØÖ·ºÍIPµØÖ·µÄÇø±ðÒÔ¼°MACµØÖ·ÔÚʵ¼ÊÓ¦ÓÃÖÐËùÉæ¼°µ½µÄ°²È«ÎÊÌâ¡£
¡¡¡¡Ò»¡¢»ù´¡ÖªÊ¶
¡¡¡¡Èç½ñµÄÍøÂçÊÇ·Ö²ãÀ´Êµ ......
1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......
//private string datapatch = ConfigurationSettings.AppSettings["acessconn"];//Êý¾Ý¿âµØÖ·
private string datapatch = "db/global.asa";//Êý¾Ý¿âµØÖ·
///
/// È¡µÃdataset
//
/// ²éѯÓï¾ä
///
public DataSet GetDataSet(string Commandtext)
{&nbs ......
Èí¼þÃû³Æ: EA2A(Excel/Access to Access)
Èí¼þ°æ±¾: beta2
ÊÚȨÐÎʽ: Ãâ·ÑÈí¼þ
ÔËÐÐƽ̨: Win9x/Me/NT/2000/XP/2003
Êý¾Ý¿âÉý¼¶ºóÔÓбíÖÐ×ֶλáÔö¼Ó£¬´ËʱÎÒÃǾÍÐèÒªµ¼È루ǨÒÆ£©Êý¾Ý£¬´Ë³ÌÐòΪʵÏִ˹¦Äܶø±àд¡£
ͨ³£Èí¼þÉý¼¶ºó£¬Êý¾Ý¿âÒ²»áÓÐËù¸Ä±ä£¬´Ëʱ¾ÍÐèÒª¶Ô¿Í»§Ê¹ÓõÄÊý¾Ý¿â½øÐÐÉý¼¶¡£Éý¼¶¿Í»§Êý¾Ý¿âµÄ·½Ê½Ó ......
public void ExportExcel(DataTable dtData, string filename)
{
System.Web.UI.WebControls.DataGrid dgExport = null;
// µ±Ç°¶Ô»°
Sy ......