Set Ca = Nothing CreateDBfile = True7 |3 v- D( h! T4 |- o! \) X9 I
End If7 x$ m% j- C- i8 I; {) U' X1 v! x
End function
0 Q8 F: W1 U& o5 B Public function CompactDatabase(byVal dbFileName,byVal DbVer,byVal SavePath)
, X4 r: ^6 r8 Y* N3 }8 t ’压缩数据库文件' E: g' ?! z( z, D" `& @+ i9 P3 J. E
’0 为access 97
* G: \& h6 e: N& Q; S+ w ’1 为access 20007 p6 i1 L, S* y& ?
On Error resume next; c/ J8 A6 S$ X9 o, A3 I
If Right(SavePath,1)"\" Or Right(SavePath,1)"/" Then SavePath = Trim(SavePath) & "\"
- Q5 [! M( Q% }/ O% R" f/ H# j5 ~ If Left(dbFileName,1)="\" Or Left(dbFileName,1)="/" Then dbFileName = Trim(Mid(dbFileName,2,Len(dbFileName)))
, d3 A7 u( ]. h' a1 L( _ If DbExists(SavePath & dbFileName) Then
2 s$ d5 r4 w& S/ Y R4 o$ w Response.Write ("对不起,该数据库已经存在!")$ s, F, I R+ v
CompactDatabase = False" v2 i2 T6 \+ s1 b9 \
Else
2 m) C X( q. O$ O5 p6 p Dim Cd5 _- z7 {: c! u( z$ y& F
Set Cd =Server.CreateObject("JRO.JetEngine")
( Q+ F: T# X N1 B' Y }, t0 K; K& n; T
If Err.number0 Then |