FE BE Compact on close

[Sess]

I could not find this in search but probably I did not search right. Anyway. I have been building an application with FE on each network station and BE on the server.
On all of the FE copies I have the checkbox for Compact on close checked ON in Tools Options General.
On the BE I have the checkbox for Compact on close checked ON in Tools Options General.

So I am wondering when the FE closes, does it only do a compact and repair on the FE or does it do the FE and BE?
If it does the FE and BE will it do the BE if another user is also data mining from the BE or will it not do it then?

 

[SOS]

The FE, if set to compact on close, will compact when closed (except that EACH user should have a copy of the FE on their machine - do NOT share a FE file unless you want your FE hosed).

The BE will compact on Close (if that option is set) when the LAST user has the last objects of the BE closed. This does not mean that they necessarily have to be out of the FE, but any objects that require the BE once all are closed it will then compact.

 

[Sess]

Thank you.
Yes I do have a copy of the FE on each machine.

So then if I have multiple users mining data from the BE it does not matter who is on first or second or whatever, it only matters who gets out last to trigger the compact. Right?

 

[SOS]

That is correct. And the backend doesn't really stay open unless an object in the backend is opened (linked table for example). If no frontend has none of those open, then it will close.

 

[Sess]

Thank you. Again.

I tried to add to your reputation but you helped me so many times that I can not boost your ego that way.




I wish your workstation was right beside mine!

 

[SOS]

Thank you. Again.

I tried to add to your reputation but you helped me so many times that I can not boost your ego that way.

Not a problem at all.

I wish your workstation was right beside mine!

Well, just remember you have hundreds of us right here inside this forum.