Automatically backup database

[mrbebop]

The database I am referring to is a split database on a LAN. I have a little knowledge of Access, but not much. Currently I am making a copy of the database file (database.mdb) to a different folder every morning for viewers to look at the plant data. It appears to be helping the balloning of the database by having the viewers look at this copied file. Unfortunately I will not be here every morning. Is it possible to have the database copied to this folder every morning at a set time, automatically?
Thanks,
Robert

 

[Mile-O]

It appears to be helping the balloning of the database by having the viewers look at this copied file.

You make it sound as if you never compact the database.

 

[mrbebop]

No sir.

On the contrary, at one time I was compacting and repairing every morning. I wouldn't care if I still had to C&R every morning, but having to call around and get everyone out of the database and and then go back and call again to see who minimised it instead of actually closing it is the pain.

 

[Mile-O]

Couldn't you set up the Windows Scheduler to compact, repair, and exit the database outside of office hours?

It's not an area where I know for definite what I'm talking about but a small routine that, on opening your database checks the time and if it's before a specific time (06:00, let's say) then the code to compact, etc runs otherwise the database opens as normal.

The Windows Scheduler, of course, would be set to open the database at the specific time: 06:00.

Just a suggestion...

 

[mrbebop]

24/7

The database users are inputting data 24/7. Most of the viewers come in at 08:00. The IT group are usually more of a pain than the problem, so I make the copy myself and C&R when it is necessary. I will look into the scheduler you suggested which I assume is on the server computer. I must have been dreaming thinking there would be some code that could be written that would take care of my woes!!! Thanks anywho!

 

[Mile-O]

If it's just to view data can't you just make a front end linking to the original database and querying the data to show reports, etc?

 

[mrbebop]

Frontend

The frontend is what I am copying to the viewing folder. There are a lot of reports in the front end already. There are a couple of people that like to view a lot of different data and then sort it the way they like it and stuff. I just like to keep them out of the working database.

 

[mrbebop]

scheduled task

I checked the server computer and the problem with that is there is no option as to where to save the backup.