Set Ca = Nothing CreateDBfile = True4 f9 ] C3 F# V8 i, x0 @$ P
End If* Y9 A/ e. `+ X/ e
End function7 {- d Y$ _0 [; m6 Q! C
Public function CompactDatabase(byVal dbFileName,byVal DbVer,byVal SavePath)
: ?! B: q; ^3 V ’压缩数据库文件
4 F: L$ @! i( F) T' @1 _ ’0 为access 97, k8 J. l G* Y0 ]0 D4 ?+ g
’1 为access 2000
1 h2 c2 P) O2 c# e4 h On Error resume next
, p2 ~, c! z2 J( H, T. o7 X If Right(SavePath,1)"\" Or Right(SavePath,1)"/" Then SavePath = Trim(SavePath) & "\"* Y# b# p, A( D' V* H' \* ]8 M
If Left(dbFileName,1)="\" Or Left(dbFileName,1)="/" Then dbFileName = Trim(Mid(dbFileName,2,Len(dbFileName)))
" h! x5 b3 ~& M& l& M% j If DbExists(SavePath & dbFileName) Then! p# P! q; N4 T9 t+ g
Response.Write ("对不起,该数据库已经存在!")
! c) q) K" `- G1 d; @/ s" r CompactDatabase = False
0 w6 R! {5 M" K* F, _$ W Else1 A: m* t) B0 Z$ H
Dim Cd8 f- Y# r' g$ J6 F g
Set Cd =Server.CreateObject("JRO.JetEngine")* R( }) I6 _2 N$ z
/ k& p6 [5 {: `6 U3 V- j If Err.number0 Then |