Yes it can. If more than one user has the database open, the compact on
close will be ignored until the last user exits.
However, you should split the database and give each user a copy of the
frontend on their computer, linked to the backend tables on the server. In
this case, setting compact on close on the backend will be ignored entirely.
You need to (and should) compact the backend by other means.
