Auto Kick & Compact

[sando]

I am finishing up my job but there will be nobody to take over from me when I leave. So what I want to be able to do is have code in the db that will automatically kick everybody out and compact the db every Friady night.

Can anyone please help

regards

 

[WayneRyan]

sando,

See Access help for "Command Line".

You can use the Windows Task scheduler to start the DB and use
the /Compact switch to do what you need.

Wayne