Compact backend on closing

[kdoran]

Is it possible to compact the backend db with the tools menu ‘compact on close’? Do I need to set this on the backend db or on the Front-end mde or both?

Also is it possible to have the backend db compact on close something like every 10 or 15 times was opened? It may be a silly idea but the reasoning would be to not slow down the closing of the db every time. It would also need to be set up to not compact when another user has it open

Thanks,

Kelly

 

[votegop]

Kelly:

I use a freeware .mdb by Peter DeBeats called CAL (Compact-a-List) which will not only compact, but will back-up one or a list of databases to the location of your choice. Once you set it up, then you create a task in your MS Task Scheduler,with a command line like (quotes and all):

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" C:\Anyfolder\cal.mdb /x execute

Set it to run late at night and as often as you like.

Once you develop your front-end, you shouldn't have to compact it. All the gobble-de-gook that happens to a file , which necessitates compacting, should only happen to the back-end.

You should also look into adding code (search Tek-tips) that will log-off idle users. You don't want anything to happen while folks are logged on.

Hope this helps.

Jay

 

[votegop]

BTW - Its Peter DeBaets, and his website is

http://www.peterssoftware.com/cal2.htm

Jay

 

[kdoran]

The only problem is that I do not have my own pc and it constantly is logged on to other users than myself

Kelly

 

[kdoran]

Thanks for the advice.

I have already written code to log off idle users. But as I stated prior I share the pc with many users and everyone logs themselves on which is why I asked the questions in my first post.

Any ideas,

Kelly

 

[votegop]

Do any of these other users use the db late at night? If not, there is no reason you can't follow my previous post.

Jay