Web Development

Repairing and compacting is the maintenance you do to deal with this aspect of Access databases
Look up compacting databases for general info on the topic and CompactDatabase for an example ofhow this can be done in code.
Hope this helps
John

There is an Access feature that allows "Admin" to set Access up so it will "Compact" automatically whenever it is closed. ALL databases act the same way once this application property is set while NO databases are open. Repeat the process on any machine, or on the server + once on each front-end machine.

There are also the posibility to add this code:

Dim fs as Object
Dim myfile

Set fs = CreateObject("Scripting.FileSystemObject")
dbEngine.CompactDatabase "Currentdb.mdb", "Nedb.mdb"

Set myfile = fs.Getfile("Currentdb.mdb")
myfile.delete
set myfile = fs.Getfile("Newdb.mdb)
myfile.rename "newdb.mdb", "Currentdb.mdb"


Not sure about the last line but as always you should debug code you get from places like this.

Hope this help!

Jesper

This question was closed by the author