M mcnewsxp Dec 20, 2004 #1 anybody have a nice way of backing up tables automatically. some linked and some not - all access jet. tia, mcnewsxp.
anybody have a nice way of backing up tables automatically. some linked and some not - all access jet. tia, mcnewsxp.
M mcnewsxp Dec 20, 2004 #2 found what i needed: sSQL = "SELECT * INTO [" & DestinationFile & "].[" & tbl.name & "] " sSQL = sSQL & " FROM [" & txtSource.Value & "\" & "EVdb_New.mdb].[" & tbl.name & "]" mconJet.Execute sSQL, , adExecuteNoRecords
found what i needed: sSQL = "SELECT * INTO [" & DestinationFile & "].[" & tbl.name & "] " sSQL = sSQL & " FROM [" & txtSource.Value & "\" & "EVdb_New.mdb].[" & tbl.name & "]" mconJet.Execute sSQL, , adExecuteNoRecords
