Compact on close

[Gkirkup]

How would I use the Access 2010 setting, 'Compact on close'?
We have a back end on a server and many users with front ends on their computers. So would I set 'Compact on close' on the back end? And then it would compact when the last user logged out?

Robert

 

[ypma]

There are a number of posts concerning compact one close repair for the back end and it does not seem easy .
To activate the compact on close for the front end is as follows you could try it also on the back end but it only seems to work if you open it up directly not when the Last front end closes
Click FILE
Click OPTIONS
Click Current Database
Click the tick box Compact on Close .
Maybe someone else can help you with the back end

 

[Gkirkup]

So would compact and repair on the FRONT end work when the last front end has closed?

Robert

 

[CJ_London]

Compact on close will only work on that instance so if every user has their own copy of the front end, only their copy will compact. If the front end only contains forms, reports, queries and code then once compacted it should not grow significantly.

Personally I do not think it is a good idea to do this automatically on close, the last thing someone wants to when they are closing down to go home is to compact the db.

This link provides a simple solution to compact the back end (I presume it is an Access back end) but in order for it to run, all users need to be logged out - and this is where the complexity starts to come in because you need to notify users who are still on the system that the db is about to be compacted and they have 10 mins to log out. Then you need a routine to cleanly boot anyone out who has gone home and not logged out etc.

http://www.access-programmers.co.uk/forums/showthread.php?t=48402