Signed StationeryI just emailed to say that compact on close is all I want.
But... ...

I have just realised that  I only want it to compact under certain
circumstances.  There is a 5 a.m. update.  The database knows it is opening
to update as a flag is set to say so...  if flag is Yes then run the
update.... else just open the database.

In the daytime the database [a backend] is multiuser.  I someone opens it
and then shuts it, it should not compact.

Is there anything like

dim db as database
set db as current db()

if flag = "Yes" then
    db.compactOnClose = true
else
    db.compactOnClose = false
end if

Steve K