Compact another DB within a Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I try to use a DBEngine.compactdatabase:

'close DB to compact - (is not a current DB)
DBExt.Close
Const confilePath = "C:\CTRC\"

' Compact the database to a temp file.
DBEngine.CompactDatabase confilePath & "ABC.mdb", confilePath &
"ABCTEMP.mdb"

But I receved a error msg "Invalid argument"
Where is my mistake?
thank you
 
Mairim said:
I try to use a DBEngine.compactdatabase:

'close DB to compact - (is not a current DB)
DBExt.Close
Const confilePath = "C:\CTRC\"

' Compact the database to a temp file.
DBEngine.CompactDatabase confilePath & "ABC.mdb", confilePath &
"ABCTEMP.mdb"

But I receved a error msg "Invalid argument"
Where is my mistake?
thank you
Click to expand...

The same code, modified for a test database of my own, works fine for
me. Are you sure the error is being raised on one of the lines you
posted?
 
Back
Top