asp Access数据备份,还原,压缩类代码-巨人网络通讯

!--#include file="config.asp" -->
!--#include file="Fun.asp" -->
%
'数据库管理类
class Datas
'备份
public sub Bk()
Set fso=server.createobject("scripting.filesystemobject")
fso.CopyFile Server.MapPath(SiteDataPath),Server.MapPath(SiteDataBakPath)
     set fso=nothing
response.Write("script language=javascript>!--
alert('备份成功！');window.location.href='DataManage.asp'
// -->/script>")
end sub

'还原
    public sub Rt()
     SDPath = server.mappath(SiteDataPath)
SDBPath = server.mappath(SiteDataBakPath)
     set Fso=Server.CreateObject("Scripting.FileSystemObject")
if Fso.FileExists(SDBPath) then
Fso.CopyFile SDBPath,SDPath
Set Fso=nothing
         response.Write("script language=javascript>!--
alert('成功：你已经成功恢复数据库!');window.location.href='DataManage.asp?action=rt'
// -->/script>")
else
         response.Write("script language=javascript>!--
alert('失败：请检查路径和数据库名是否存在');window.location.href='DataManage.asp?action=rt'
// -->/script>")
end if
    end sub

    '压缩
    public sub Dc()
     SDBPath = server.mappath(SiteDataBakPath)
     set Fso=Server.CreateObject("Scripting.FileSystemObject")
     if Fso.FileExists(SDBPath) then
Set Engine =Server.CreateObject("JRO.JetEngine")
     if request("boolIs") = "97" then
     Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" SDBPath, _
         "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" SDBPath "_temp.mdb;" _
         "Jet OLEDB:Engine Type=" JET_3X
     else
     Engine.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" SDBPath, _
         "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" SDBPath "_temp.mdb"
end if
Fso.CopyFile SDBPath "_temp.mdb",SDBPath
Fso.DeleteFile(SDBPath "_temp.mdb")
set Fso = nothing
set Engine = nothing
     response.Write("script language=javascript>!--
alert('成功：数据库已经压缩成功!');window.location.href='DataManage.asp?action=dc'
// -->/script>")
else
     response.Write("script language=javascript>!--
alert('失败：数据库压缩失败，请检查路径和数据库名是否存在！');window.location.href='DataManage.asp?action=dc'
// -->/script>")
end if
    end sub
end class
%>

标签：通化荆门普洱运城通辽鹰潭巴彦淖尔雅安

巨人网络通讯声明：本文标题《asp Access数据备份,还原,压缩类代码》，本文关键词 asp,Access,数据备份,还原,；如发现本文内容存在版权问题，烦请提供相关信息告之我们，我们将及时沟通与处理。本站内容系统采集于网络，涉及言论、版权与本站无关。