Guest OM Posted October 2, 2007 Posted October 2, 2007 Hi, I have an access database that is shared by the network users. These users tend to forget to close the applications when they finish their work at the end of the day. This makes the server unable to backup the file (being open). Can someone advice me how to gracefully close the file when all users are longer using the db (even though their application might still be open)? Thanks
Guest Mathieu CHATEAU Posted October 2, 2007 Posted October 2, 2007 Re: how to gracefully close an access db on a shared folder Hello, gracefully doesn't mean respecting the application logic. This application may does things when closing up (like freeing opened business case...) that can't be played. You can use net session /delete /yes or net file XX /close but you need a way to find the id. It's much better to logoff users on workstations before starting backup, so you also backup roaming profile and prevent unconsistent application behaviour the next morning. -- Cordialement, Mathieu CHATEAU English blog: http://lordoftheping.blogspot.com French blog: http://www.lotp.fr "OM" <om@discussions.microsoft.com> wrote in message news:%233tOW6RBIHA.5868@TK2MSFTNGP05.phx.gbl... > Hi, > > I have an access database that is shared by the network users. These users > tend to forget to close the applications when they finish their work at > the end of the day. This makes the server unable to backup the file (being > open). Can someone advice me how to gracefully close the file when all > users are longer using the db (even though their application might still > be open)? > > Thanks
Guest Alang Posted October 3, 2007 Posted October 3, 2007 Re: how to gracefully close an access db on a shared folder On Tue, 02 Oct 2007 11:03:49 -0700, OM <om@discussions.microsoft.com> wrote: >Hi, > >I have an access database that is shared by the network users. These >users tend to forget to close the applications when they finish their >work at the end of the day. This makes the server unable to backup the >file (being open). Can someone advice me how to gracefully close the >file when all users are longer using the db (even though their >application might still be open)? > >Thanks I can't tell you how to close off the user end but I have used an access 2000 DB for the past few years and backed it up nightly with no problems. Make sure your DB is split into a backend and frontends. Locate the copies of the frontends on the client computers with a link to the tables on the backend on the server. Even if the client is logged on you can still make a copy of the backend tables. We don't run ours off the domain server. We use an old win98 file server and a free utility called taskzip that can run timed backups. In 9 years of running an access db this way we have rarely had any problems with backups. You may get a better answer on the Access newsgroups
Guest OM Posted October 3, 2007 Posted October 3, 2007 Re: how to gracefully close an access db on a shared folder Thanks for the input
Recommended Posts