(鍏跺疄鎴戜笉鏄綉绠★紝璇︽儏璇风湅……) 鍏充簬缃戠涔嬭矾鐨勮鏄

閫氳繃娣诲姞闃蹭笅杞藉瓧娈垫潵闃叉ACCESS鏁版嵁搴撹涓嬭浇鐨勬柟娉

     鐩镐俊澶у鍦ㄥ紑鍙戜竴浜涘皬鍨嬬綉绔欑殑鏃跺欙紝甯稿父浼氶夋嫨ASP+ACCESS缁勫悎锛屽彲鏄疉CCESS鏁版嵁搴撴湁涓涓嚧鍛界殑缂虹偣灏辨槸瀹规槗琚笅杞姐傚ぇ瀹剁煡閬擄紝涓涓綉绔欑殑绉樺瘑鍏跺疄灏辨槸鏁版嵁搴擄紝鏁版嵁搴撳鏋滆涓嬭浇浜嗭紝涓嶇敤鎴戣杩欐剰鍛崇潃浠涔堜簡鍚с傛渶甯哥敤鐨凙CCESS闃蹭笅杞界殑鏂规硶锛屾槸鎶婃暟鎹簱鐨勬墿灞曞悕鏀规垚.asp锛屾垨鑰呭湪鏁版嵁搴撳悕鍓嶅姞#鍙风瓑绛夛紝浣嗛兘璧蜂笉鍒扮湡姝g殑浣滅敤锛屼粛鐒跺彲浠ョ牬瑙d笅杞芥暟鎹簱锛屾渶濂界殑鏂规硶灏辨槸鍦ˋCCESS鏁版嵁搴撲腑娣诲姞闃蹭笅杞藉瓧娈碉紝鍏蜂綋鏂规硶濡備笅锛

    鍑嗗宸ヤ綔锛

    1銆佸畨瑁匒CCESS鏁版嵁搴撹蒋浠

    2銆佹柊寤轰竴涓狝CCESS鏁版嵁搴擄紝杩欓噷鍋囪涓htmer_db.mdb

    娣诲姞ACCESS闃蹭笅杞藉瓧娈碉細

    1銆佹墦寮鏂板缓鐨刪tmer_db.mdb鏁版嵁搴擄紝鐐瑰嚮“瀵硅薄”涓殑“鏌ヨ”閫夐」锛岀劧鍚庡弻鍑“鍦ㄨ璁¤鍥句腑鍒涘缓鏌ヨ”閫夐」锛岀浉鍏虫埅鍥惧涓嬫墍绀猴細

    2銆佸湪寮瑰嚭鐨“鏄剧ず琛”绐楀彛涓偣鍑“鍏抽棴”鎸夐挳锛屾鏃跺湪宸ュ叿鏍忎腑浼氬鍑轰竴涓猄QL鍥炬爣锛屽崟鍑昏鍥炬爣锛岀浉鍏虫埅鍥惧涓嬫墍绀猴細

    3銆佸湪寮瑰嚭鐨勬煡璇㈢獥鍙d腑杈撳叆濡備笅璇彞鍚庣偣鍑昏繍琛屾寜閽紙鍗冲伐鍏锋爮涓殑鎰熷徆鍙凤級锛

    Create Table [htmer_notdown]([htmer] oleobject)

    鐩稿叧鎴浘濡備笅鎵绀猴細

    涓婇潰璇彞鐨勮鏄庯細鍒涘缓浜嗕竴涓悕涓“htmer_notdown”琛紝鍏朵腑鐨勫瓧娈靛悕绉颁负“htmer”锛屽瓧娈电被鍨嬩负“OLE瀵硅薄”銆

    4銆佸皢鏌ヨ绐楀彛涓殑璇彞鍒犻櫎锛屽苟杈撳叆濡備笅璇彞鍚庤繍琛岋紝杩愯鐨勬椂鍊欎細鎻愮ず鏄惁杩藉姞1琛岋紝鐐瑰嚮“鏄”鎸夐挳锛

    Insert into [htmer_notdown](htmer) values(0x3C25)

    鐩稿叧鎴浘濡備笅鎵绀猴細

    涓婇潰璇彞鐨勮鏄庯細鍚“htmer_notdown”琛ㄧ殑“htmer”瀛楁涓彃鍏“0x3C25”鏁版嵁锛“0x3C25”涓哄瓧绗“<%”鐨16杩涘埗锛夈

    5銆佸叧闂煡璇㈢獥鍙o紝姝ゆ椂鎻愮ず浣犳槸鍚﹁淇濆瓨锛岄夋嫨鍚﹀嵆鍙傛鏃禔CCESS闃蹭笅杞藉瓧娈靛氨娣诲姞瀹屾垚浜嗭紝鍒囨崲鍒“琛”瀵硅薄锛屼細鍙戠幇閲岄潰澶氫簡涓涓〃htmer_notdown锛屾墦寮鍚庡彂鐜板瓧娈垫樉绀虹殑鏄“闀夸簩杩涘埗鏁版嵁”锛岀浉鍏虫埅鍥惧涓嬫墍绀猴細

    6銆佸皢htmer_db.mdb鏁版嵁搴撴敼鍚嶄负htmer_db.asp

    鍘熺悊鍒嗘瀽锛鍥犱负褰撴暟鎹簱鐨勬墿灞曞悕鍙樻垚ASP鏍煎紡鍚庯紝浠庤繙绋嬭闂繖涓枃浠剁殑鏃跺欙紝IIS鏈嶅姟鍣ㄥ氨浼氭妸瀹冨綋鎴怉SP绋嬪簭鏉ユ墽琛岋紝鑰屾垜浠箣鍓嶅湪ACCESS鏁版嵁搴撲腑鎻掑叆浜“<%”绗﹀彿锛岃孉SP绋嬪簭蹇呴』鍦<%%>鏍囪涓墠鑳芥墽琛岋紝鎵浠ュ氨浼氬嚭鐜“缂哄皯鑴氭湰鍏抽棴鏍囪”鐨勯敊璇傜敱浜庤繖涓敊璇紝鎵浠ヤ汉瀹跺氨鏃犳硶涓嬭浇ACCESS鏁版嵁搴撲簡锛屼篃灏辫揪鍒颁簡ACCESS鏁版嵁搴撻槻涓嬭浇鐨勭洰鐨勩




鏂囩珷鏉ヨ嚜: 缃戠粶杞浇
Tags: 瀹夊叏 access 鏁版嵁搴 鏂规硶
鐩稿叧鏃ュ織:

鐗瑰埆澹版槑锛
鈶 鏈珯鍙戣〃鐨勬棩蹇椾粎灞炰釜浜鸿鐐癸紱
鈶 鏃ュ織涓湭娉ㄦ槑"绂佹杞浇"瀛楁牱鐨勬枃绔狅紝濡傞渶杞浇锛岃娉ㄦ槑鍑哄锛屽苟涓斾繚鐣欐鏃ュ織鐨勯摼鎺ワ紱
鈶 绂佹鐩楅摼鏈珯鎵鏈夊浘鐗囥佽蒋浠躲佸奖闊虫枃浠跺湴鍧锛
鈶 鏈珯鎻愪緵涓嬭浇鐨勮祫婧愶紝浠呬緵鍙傝冩垨娴嬭瘯,涓嬭浇璇疯嚜琛屾潃姣掋傚閫犳垚浠讳綍涓嶈壇鍚庢灉锛屾涓嶈礋璐o紱
鈶 濡傛湁浠讳綍鐤戦棶锛岃闅忔椂涓庣珯闀胯仈绯伙細webmaster#smoile.com | smoile's缃戠涔嬭矾 銆
鈶 JPG鏍煎紡璇蜂娇鐢ACDSee宸ュ叿闃呰锛孭DF鏍煎紡璇蜂娇鐢Adobe Reader闃呰锛孌OC鏍煎紡璇蜂娇鐢∣ffice Word闃呰锛孯AR鏍煎紡璇风敤WINRAR闃呰銆
鍏嶈矗澹版槑:
銆銆姝ら〉闈㈡彁渚涚殑鏂囦欢鍧囬氳繃NOD32鏉姣掕蒋浠舵壂鎻忔棤姣锛岃鏀惧績浣跨敤锛屼絾涔熺儲璇锋偍鍦ㄤ笅杞藉悗鍐嶆煡姣掍竴娆$‘淇濇枃浠跺畨鍏紝濡傛湰鏂囦欢瀵规偍鐨勮绠楁満閫犳垚鍗卞锛屾湰绔欎笉璐熻矗浠汇
銆銆鏈珯鎵鍒婅浇鍐呭鍧囦负涓汉鎾板啓鎴栦粠缃戠粶涓婃敹闆嗘暣鐞嗭紝骞朵笖浠ヨ绠楁満鎶鏈爺绌朵氦娴佷负鐩殑锛屼粎渚涘ぇ瀹跺弬鑰冿紝涓嶅瓨鍦ㄤ换浣曞晢涓氱敤閫斻備笉寤鸿鎮ㄥ皢鍏跺綋浣滄妧鏈缓璁垨鎿嶄綔寮曞鑰屾牴鎹叾鐩存帴琛屼簨銆傝嫢鎮ㄩ渶瑕佹妧鏈湇鍔★紝鎮ㄥ簲褰撴寮忓鎵樹笓涓氬叕鍙镐互淇濋殰鎮ㄧ殑鍚堟硶鏉冪泭銆傝繖浜涗俊鎭湁鍙兘涓嶆槸鏈鏂扮殑銆佸畼鏂圭殑淇℃伅锛屼篃鍙兘鏄负浜嗙爺绌舵煇涓鎶鏈棶棰樿屾彺寮曡嚜浠栧锛屽彲浠ヤ笉缁忛氱煡鑰屾洿鏀广傚鏋滄湰缃戠珯鍐呭涓嶆厧渚电姱浜嗘偍鐨勭増鏉冿紝璇蜂笌鎴戣仈绯伙紝鎴戝皢鍙婃椂澶勭悊锛屾挙涓嬬浉鍏冲唴瀹癸紒
璇勮: 4 | 寮曠敤: 0 | 鏌ョ湅娆℃暟: 3603
灏忔彁绀猴細鏂囦欢涓嬭浇涓嶄簡锛熶负浜嗛槻姝㈢洍閾炬帴锛屾湰绔欏仛浜嗘妧鏈鐞嗭紝闇瑕佷笅杞界殑缃戝弸璇烽槄璇杩欓噷锛岃幏鍙栭閫熶笅杞藉湴鍧銆
鍙戣〃璇勮
涓洪槻姝㈡敞鍐屾満鐨勪娇鐢,鏈郴缁熷凡绂佹UBB浠g爜锛
璇峰湪鐣欒█涓嬁浣跨敤杩欎簺鍏抽敭瀛
鏄点绉:
瀵嗐鐮: 娓稿鍙戣█涓嶉渶瑕佸瘑鐮.
楠岃瘉鐮:
鍐呫瀹:
閫夈椤:
铏界劧鍙戣〃璇勮涓嶇敤娉ㄥ唽锛屼絾杩樻槸寤鸿鎮娉ㄥ唽璐﹀彿(姣忓ぉ0鈥8鐐圭姝㈡敞鍐).
瀛楁暟闄愬埗 1000 瀛 | UBB浠g爜 鍏抽棴 | [img]鏍囩 鍏抽棴