Automatically Backing up Access Database

[buddylove69]

Hi!

I have a problem and I need a very quick HELP!
I need to backup and access2000 database automatically (every hour) using VB 6.0. I need the exact code in order to perform that task. Please if someone can help me, I would be greatful.

By the way.....the database ahas a password.

Thank you.

[Gary.Lowe]

You could use this. This is the compact routine but can act as a sort of backup

Make sure you reference the Microsoft ADO Ext. 'Version' for DDL and Security.

Dim je As New JRO.JetEngine
 
   ' Make sure there isn't already a file with the
   ' name of the compacted database.
   If Dir("C:\BackUp\YourDB.mdb") <> "" Then Kill ".\NewNorthWind.mdb"
 
   ' Compact the database
   je.CompactDatabase "Data Source=C:\YourDB.mdb;Jet OLEDB: Database Password=password;", _
      "Data Source=C:\BackUp\YourDB.mdb;"

[buddylove69]

I thank you ver much for your time sir.

What I need though, is that the backup to take effect automatically every hour of the day.

Please help me on that.

P.S. Is compacting same as backup?

[frigginjerk]

you could place a timer control on a hidden form. This form should also display a label control which tells the user that a backup is taking place, and to wait. Place something like this on your hidden form:
------------------------
Dim i As Byte

Private Sub Form_Load()
i = 0
End Sub

Private Sub Timer1_Timer()
i = i + 1
If i = 60 Then
Form1.Show vbModal
Timer1.Enabled = False
'1. disconnect from the databse
'2. compact or copy database
'3. reconnect to databse
i = 0
Timer1.Enabled = True
Form1.Hide
End If
End Sub
-----------------------------

note that the timer control is kinda unreliable and that it is better to use the windows api functions.

this is just an idea, sorry i can't give exact code.
well gotta i go study now, good luck.

[frigginjerk]

sorry i forgot to mntion that your timer interval should be set to 60000, so that it will go off every minute.

[gab2001uk]

Why not replicate your database, then set a timer to go off every hour and synchronise the two. You do not need to disconnect any users, as you would for compacting, as the synch process can be carried out on open and active databases.

[gab2001uk]

Here 2 projects that do just that. One uses DAO the other ADO / ADOX / JRO.
Have fun