backup up tables

mcnewsxp · Dec 20, 2004

anybody have a nice way of backing up tables automatically.
some linked and some not - all access jet.
tia,
mcnewsxp.

mcnewsxp · Dec 20, 2004

found what i needed:

sSQL = "SELECT * INTO [" & DestinationFile & "].[" & tbl.name & "] "
sSQL = sSQL & " FROM [" & txtSource.Value & "\" & "EVdb_New.mdb].[" &
tbl.name & "]"
mconJet.Execute sSQL, , adExecuteNoRecords