Compact on Close

[hfsitumo2001]

In order to improve performance, is it good, if on Option on current database, we put " Compact on Close" to True?

 

[Isaac]

Given that you split your database, and each user's front end only has non-data objects (forms, reports, queries), I would recommend not checking this option.

 

[hfsitumo2001]

Given that you split your database, and each user's front end only has non-data objects (forms, reports, queries), I would recommend not checking this option.

Thank you Isaac.

 

[isladogs]

In certain circumstances, compact on close can cause corruption.
Its far less common now than used to be the case 20+ years ago, but I wouldn't risk it either.
It will just slow down closing your FE database for little benefit.
As Isaac said there should be little need to compact the FE in a split database as it shouldn't get 'bloated'

 

[isladogs]

Yes I see your point, but I split my databases early on during the development cycle and prefer to have control over when compacting is done.
If I were to implement compact on close, I would also implement creating an automatic backup before closing