we have an application built around Ms Access 2007 with a lot of VB code in place. Multiple users are in the system all day and night long. Intermittently.
We have a backup process that normally takes place at 5 am in the morning. We have instructed our staff to be out of the system during the hours 5 am to 5:30 sometimes they are sometimes not. When they are not out of the system it causes the backup to fail. Something we run on Task Scheduler.
Would one or all of the following work......?
1. Switch the Access 2007 database to a SQL Server DB....? We want to keep the Access user interface though.
2. Create code that informs the users he must get out( log out) ....finish his work etc so the system can be off for that 5 to 5:30 period........if so where do we find the code.for that. Even a backup email might be good too.
How could we solve this problem. Your support is greatly appreciated.