Automatic backup

[timpepu]

Hi !

How I can make automatic backup access database , now I have made it with filecopy but it doesn't work because the file is open

Function Backup()



Dim CurrentDate As String
Dim currentime As String
CurrentDate = Date
CurrentDate = Format(CurrentDate, "DDMMYY")
FileCopy "\\Public\thy.mdb", "\\backup\thy" & "_" & Format(Date, "DD-MM-YY") & ".mdb"
End Function

[NTC]

this isn't really an Access question; it is a TaskManager question of the OS.

[timpepu]

Hi !

In my mind it is really an Access question if I'm trying to run it automaticly from Access ??????

[NTC]

well I will haggle on that point; as in any case it is still a system command you are dealing (file copy) with and would be identical whether or not you were in any of the Office products.....plus the term "automatic" implies unintended - where inside Access it is triggered by an event.

But be that as it may; one assumes that one really needs to back up just the data - thus you should split the db - and then trigger the copy of the BE only. It will permit you to do that while in Access. One will never be able to copy the FE while in it because the .ldb exists - but there should never be a need for this.

[drramini]

I know it's too late. I was looking for such code to make a backup for me. First of all, thank you for the code you supplied. Second of all, the access needs to close the database to make a copy. Then, if you add "DoCmd.Quit" before the copy, as I did on a Quit bottom, the code works, so when you close the database, it automatically copies and backups.

well I will haggle on that point; as in any case it is still a system command you are dealing (file copy) with and would be identical whether or not you were in any of the Office products.....plus the term "automatic" implies unintended - where inside Access it is triggered by an event.

But be that as it may; one assumes that one really needs to back up just the data - thus you should split the db - and then trigger the copy of the BE only. It will permit you to do that while in Access. One will never be able to copy the FE while in it because the .ldb exists - but there should never be a need for this.