<% '#######以下是一個(gè)類文件，下面的注解是調(diào)用類的方法 '# 注意：如果系統(tǒng)不支持建立Scripting.FileSystemObject對(duì)象， 那么數(shù)據(jù)庫(kù)壓縮功能將無(wú)法使用 '# access 數(shù)據(jù)庫(kù)類 '# CreateDbFile 建立一個(gè)Access 數(shù)據(jù)庫(kù)文件 '# CompactDatabase 壓縮一個(gè)Access 數(shù)據(jù)庫(kù)文件 '# 建立對(duì)象方法: '# Set a = New DatabaseTools
Class DatabaseTools
Public function CreateDBfile(byVal dbFileName,byVal DbVer,byVal SavePath) '建立數(shù)據(jù)庫(kù)文件 'If DbVer is 0 Then Create Access97 dbFile 'If DbVer is 1 Then Create Access2000 dbFile On error resume Next If Right(SavePath,1)<>"/" Or Right(SavePath,1)<>"/" Then SavePath = Trim(SavePath) & "/" If Left(dbFileName,1)="/" Or Left(dbFileName,1)="/" Then dbFileName = Trim(Mid(dbFileName,2,Len(dbFileName))) If DbExists(SavePath & dbFileName) Then Response.Write ("對(duì)不起，該數(shù)據(jù)庫(kù)已經(jīng)存在!") CreateDBfile = False Else Dim Ca Set Ca = Server.CreateObject("ADOX.Catalog") If Err.number<>0 Then Response.Write ("無(wú)法建立，請(qǐng)檢查錯(cuò)誤信息<br>" & Err.number & "<br>" & Err.Description) Err.Clear Exit function End If If DbVer=0 Then call Ca.Create("Dim fso Set fso = CreateObject("Scripting.FileSystemObject") If Err.number<>0 Then Response.Write("刪除文件發(fā)生錯(cuò)誤!請(qǐng)查看錯(cuò)誤信息<br>" & Err.number & "<br>" & Err.Description) Err.Clear DeleteFile = False End If call fso.DeleteFile(filespec) Set fso = Nothing DeleteFile = True End function
Public function RenameFile(filespec1,filespec2) '修改一個(gè)文件 Dim fso Set fso = CreateObject("Scripting.FileSystemObject") If Err.number<>0 Then Response.Write("修改文件名時(shí)發(fā)生錯(cuò)誤!請(qǐng)查看錯(cuò)誤信息<br>" & Err.number & "<br>" & Err.Description) Err.Clear RenameFile = False End If call fso.CopyFile(filespec1,filespec2,True) call fso.DeleteFile(filespec1) Set fso = Nothing RenameFile = True End function
