If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

sorry ok... here is what i'm goin to do from the login screen when it closes it will open a form hidden in the background that will keep track of the time and refresh every second based on the timer.. when the text box = 5:35 pm it will then do all backups and close. I am only putting this on my version of the program so that it will not duplicate backups from the other users.

Sounds kind of risky to me...
how are you making sure there are no users updating the db whilst you run your backup. Just saying no one uses it after 17:35 is taking a heck of a risk, especailly as over time the reason for logging out by then willhave slipped from many peoples minds.

It may be worthwhile to use some function that forces users to disconnect (not sure where I came accross it (possibly Allen Brownes site)), I'd also consider using the lockfile manipulation programs to stop new people logging in when you want to perform a maintenance task.

Mind you, why do it through Access, couldn't you do it as a straightforward dos copy at some truly odd hour of the night, or possibly very early in the morning. Users often seem happy to stay on outside normal hours, but rarely (thank god) come in early.

Sounds like you need to consider having a proper backup system, triggered by a timer / scheduler. Needn't be anything fancy such as to tape but you could dump the files to hard disk and write to CD manually the following day.

If you can't track down the lockout program drop a note there and I will try to find it at work on Monday
HTH

well just to let you know the physical environment that i am in... there are only 7 people in my office and I can see everyone of them at once. Also, I am only putting that form on my computers front end. If I am out they do know to have my computer on for the end of the day... or I can just take care of it from home.