How I Can make a copy of access whith a limited time

[root7]

How I Can make a copy of access whith a limited time for example if the time become 2:00 clock will be maken a copy of access in a folder I will choos and then it will replace this access even if open

 

[SOS]

Can you explain, in a little more detail, what the purpose of replacing the database at a specific time, even if a user is using it, would be?

 

[root7]

get copy for the database After Update

 

[SOS]

If you mean make sure that everyone has the latest copy of the frontend after you've made changes, why not use something like an auto updater.

Bob Larson has a free tool which will turn your frontend into an auto updating frontend. Or Tony Toews has a free auto updater which runs differently but will essentially do the same.

 

[root7]

Want copy database by vb6 not by access
Thank you

 

[DCrake]

Here is a snippet of code used in VB6 to make a copy of a database

Private Sub BtnBackup_Click()
Dim nFile As String
nFile = Me.TxtNewMdb & "\" & Me.TxtFileName
If Dir(nFile) <> "" Then
    If MsgBox(nFile & " already exists, do you want to overwrite it?", vbExclamation + vbYesNo, "Duplicate File Found") = vbYes Then
        Kill Dir(nFile)
    Else
        Exit Sub
    End If
End If

FileSystem.FileCopy "C:\Program Files\Club Manager\ClubData.mdb", nFile
MsgBox "Back up of data complete", vbInformation + vbOKOnly, "Club Manager ©"
Unload FrmBackup

End Sub

 

[root7]

Thank you, this is code take copy from database but not in specific time.
e.g. i want run program in 2 a.m. and take copy from database.
Thank you again for help me.

 

[DCrake]

What you really want is a schedule setting up to commences at 2am that runs a batch file that does the copy.

David

 

[root7]

yes, i think that

 

[root7]

I was search for programs to specified time and i found two programs in Visual Basic can ShutDown a computer in specific time, i want like this timer when i choose 2 a.m. then a program take a copy of database without controling from me on a program in that time(2 a.m.)
and this is two links for two programs:
http://www.codeproject.com/KB/vb/shutdowntimer.aspx
http://www.codeproject.com/KB/vb/Amr.aspx

 

[DCrake]

If you set up a schedule in MS scheduler

Start > Settings > Control Panel - Scheduled Tasks.

Then add a new task this should do it for you. Don't know if will copy an open database though.

David

 

[SOS]

You can't overwrite an open database. It won't work. You would have to implement some sort of kick out mechanism. There is a sample one here.