Set Ca = Nothing CreateDBfile = True' S4 \' v, T7 ]( L
End If- e0 [% \" @8 F* m i+ J/ I/ V
End function7 F5 y4 Y/ J( b. @$ i$ r! q/ ]
Public function CompactDatabase(byVal dbFileName,byVal DbVer,byVal SavePath)1 O& w7 @0 \! k( B' x$ W' O
’压缩数据库文件, T( n7 S, j4 X+ A# \
’0 为access 97
$ i0 Q! u; p g; w ’1 为access 2000, n5 @4 {. ?& ^/ L% [ I3 x) l
On Error resume next
& p& B! b. `1 t$ ~8 L( n+ h; f If Right(SavePath,1)"\" Or Right(SavePath,1)"/" Then SavePath = Trim(SavePath) & "\"
4 K1 \6 T2 X; { If Left(dbFileName,1)="\" Or Left(dbFileName,1)="/" Then dbFileName = Trim(Mid(dbFileName,2,Len(dbFileName))) D3 D2 G7 l: ]" O1 V5 y7 T' A
If DbExists(SavePath & dbFileName) Then7 {$ D8 Y) n4 u+ H9 b1 } c
Response.Write ("对不起,该数据库已经存在!")
' M8 s& v* O( o2 J; H8 N7 e5 }/ b CompactDatabase = False
8 t( \# q" P3 f7 v$ V; | Else9 w% D; N- Z4 ^) T
Dim Cd
4 F/ K3 S- H/ N# L* P9 Q Set Cd =Server.CreateObject("JRO.JetEngine")% i( I) j L( d1 B( Z t H
If Err.number0 Then
# L5 u: v; {9 I S4 j+ M& F# y Response.Write ("无法压缩,请检查错误信息6 }! o3 w& B, K' f
" & Err.number & "* D [: I! O+ p" a' J$ `+ I( u
" & Err.Description)
" n4 o) u7 N; D7 [) p, {3 n Err.Clear
3 c+ v: g- j0 g7 A Exit function
% \9 ^2 h" F* O% q' S: q" Y# z9 G2 [4 t2 N7 [8 P* {* G
End If |