HELLO!
I would like compact my ACCESS DATABASE with a vb code
How can i do?
Thank's
Cybercool
Printable View
HELLO!
I would like compact my ACCESS DATABASE with a vb code
How can i do?
Thank's
Cybercool
Ensure database is closed. This can be checked by looking for a the database name with an extension of LDB. The dbName must include the the path where the database is included
dbName = App.Path & "\MyDB.mdb"
DBEngine.CompactDatabase dbName, dbName & "!!!"
Kill dbName
Name dbName & "!!!" As dbName