Compact backend of databse while front Open

[cwby1966]

Can someone give some advice on this . I have a split db, we want to compact the backend and the end of a process. This DB is running in virtual office.
Thanks

[Rabbit]

CompactDatabase "File Path", "Compacted File Path" ' Must be different
Kill "File Path"
FileCopy "Compacted File Path", "File Path"
Kill "Compacted File Path"

[NeoPa]

As there may be situations where the file(s) are locked, it's probably a good idea to use 'On Error Resume Next' code to allow this code to process through.

On Error Resume Next
CompactDatabase "File Path", "Compacted File Path" ' Must be different
Kill "File Path"
Name "Compacted File Path" As "File Path"
Kill "Compacted File Path"
On Error Goto 0

Also, probably better to use the rename command (Name ... As ...) rather than a copy.

[Rabbit]

I only used the Copy because I couldn't find the rename command lol. Actually, I was looking for a move command and couldn't find that either.

Either way, you would get rid of the last kill statement if you use the rename command.

[NeoPa]

I only used the Copy because I couldn't find the rename command lol. Actually, I was looking for a move command and couldn't find that either.

I believe the Name command can work as a move in the same way as the 'mv' command in Unix does both. You'd have to test to be sure though.

Either way, you would get rid of the last kill statement if you use the rename command.

In fact, if it hadn't been there already I would have added it.
Consider the rename failing due to the file being open when the rename is attempted. This code won't give proper error messages, but at least in that case it will tidy up the file that's left behind.