Ado Using MDB. Leaves .ldb file in directory.
Posted on 2002-04-29
I am using ADO and need to compact the database after deleting a large number of records.
x = rs.RecordCount
If x > 0 Then
cnn.Execute "Delete From Table1"
DBEngine.CompactDatabase Infile, OutFile, ";pwd=admin", , ";pwd=admin"
On quite a large number of occassions i am ending up the the infiles's .ldb file still on the disk, with a zero block size.
I am therefore getting an access denied error., when trying to compact.
I then have to open the infile in Access, close it. This gets rid of the .ldb file.
Would appreciate any help