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);
 
Ïà¹ØÎĵµ£º
ʹÓÃÁËTCP/IP£¬ADO¼°XML£¨ÐèÒª°²×°Microsoft XML 4.0¡££©¡£·Ö·þÎñÆ÷ºÍ¿Í»§¶ËÁ½²¿·Ö£¬·þÎñÆ÷¿ÉÒÔ¶àÓû§Í¬Ê±Á¬½Ó¡£Ô¶³ÌÁ¬½ÓAccessÊý¾Ý¿âÓкܶ෽·¨£¬ÎÒÒÔǰÒѾ±È½Ï¾ßÌåµÄ»Ø´ð¹ý£¨¼ûÏÂÃæËùÁеÄ5ÖÖ·½·¨£©£¬ÎÒÏÖÔÚÕâ¸öÀý×ÓÊôÓÚÆäÖеĵڣ³ÖÖ·½·¨£¨²»ÐèҪʹÓÃRDS»òWeb·þÎñÆ÷£©¡£
Ô¶³ÌÁ¬½ÓaccessÊý¾Ý¿âµÄ¼¸¸ö·½·¨£º
£±£®½¨Á¢VPN ......
1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......
1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......
Îı¾ nvarchar(n)
±¸×¢ ntext
Êý×Ö(³¤ÕûÐÍ) int
Êý×Ö(ÕûÐÍ) smallint
Êý×Ö(µ¥¾«¶È) real
Êý×Ö(Ë«¾«¶È) float
Êý×Ö(×Ö½Ú) tinyint
»õ±Ò money
ÈÕÆÚ smalldatetime
²¼¶û bit
¸½£º×ª»»³ÉSQLµÄ½Å±¾¡£
ALTER TABLE tb ALTER COLUMN aa Byte Êý×Ö[×Ö½Ú]
ALTER TABLE tb ALTER COLUMN aa Long Êý×Ö[³¤ÕûÐÍ]
ALTER T ......