Thanks for the reply. I am new to MS Access and have no much idea about implementing this using the timer event. It would be helpful if you can provide a sample code that gives me idea of how it looks like. Also, are you saying this cannot be implemented without involving front end? Because...
Hi,
I have a Ms Access split database where in the backend database grows up very fast and needs to be compressed everyday. I have written a batch script to compact the same and have scheduled it to be run every night. But the script is unable to compress the backend every time since the users...