coping file to a:

[fdelpuerto]

Hi, I need to make db backup From my vbproject when db is running.

a) it's necessary to close db before, and how is better to do that?
b) drive a need to have free space, how I know free disk space?
c) How can I compact database from vbcode?

then, it's enough to make a copy?

[COLOR=blue]FileCopy[/COLOR]  C:\DataBase1,A:\DataBase1

And, the last question...how I know when the copy is end, for open db again

Thank, sorry by my english

[Michael_Kamen]

You'll have to close the database before copying yes.
Just close the recordsets and the database.

RecordSet.Close
Set RecordSet = Nothing
Database.Close
Set Database = Nothing

To get the amount of free space:

Private Declare Function GetDiskFreeSpace Lib "kernel32" Alias "GetDiskFreeSpaceA" (ByVal lpRootPathName As String, lpSectorsPerCluster As Long, lpBytesPerSector As Long, lpNumberOfFreeClusters As Long, lpTtoalNumberOfClusters As Long) As Long
 
Private Sub Form_Load()
    'KPD-Team 1998
    'URL: [url]http://www.allapi.net/[/url]
    'E-Mail: [email][email protected][/email]
 
    Dim Sectors as Long,Bytes as Long,FreeC as Long, TotalC as Long,Total as Long,Freeb as Long
    'Retrieve information about the C:\
    GetDiskFreeSpace "a:\", Sectors, Bytes, Freec, Totalc
MsgBox "Free bytes:" + Str$(Freeb)

What exactly do you mean with "compact" your database?

Do you mean you want to compress it?
That's pretty hard, in VB, I think..

[fdelpuerto]

It's ok, but how I know when the copy is end, for open db again