hi all helpers,
got a problem on Delete all records in a table ABC, coding as below, appreciate any adv....tks a lot.
[VBA]Dim myDB As DAO.Database
Dim myTable As String
Dim mySql As String
myTable ="ABC"
Set myDB = CurrentDb
'mySql = "DELETE * FROM " & myTable ' have tried this but not work
mySql = "DELETE " & myTable & ".* FROM " & myTable
myDB.Execute (mySql)[/VBA]
beginner