一般來說,access與asp一起鏈接使用,下面南京北大青鳥的老師就以asp代碼為示例來展示一下壓縮代碼
<%
oldDB = server.mappath("db.mdb")
newDB = server.mappath("db_new.mdb")
Set FSO = Server.CreateObject("Scripting.FileSystemObject")
Set Engine = Server.CreateObject("JRO.JetEngine")
prov = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
Engine.CompactDatabase prov & OldDB, prov & newDB
set Engine = nothing
FSO.DeleteFile oldDB
FSO.MoveFile newDB, oldDB
set FSO = Nothing
response.write "OK"
%>
其原理就是通過fso對舊的數據庫數據進行復制,然后刪除舊數據庫更改新數據庫名稱,簡單而有效
其原理就是通過fso對舊的數據庫數據進行復制,然后刪除舊數據庫更改新數據庫名稱,簡單而有效