var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete All Records From A Table In Another Database
Using Access 2007.
I would like to delete all records from a table in another database before I append new records to it.
My SQL string is giving a Type Mismatch error
Any idea what might be wrong?
strSQL = ""
strSQL = strSQL & "DELETE .* " & _
strSQL = strSQL & "FROM SFDC_New " & _
strSQL = strSQL & "IN ""C:\Data\Foo.accdb""; "
db.Execute strSQL, dbFailOnError
Dim strSQL As String
strSQL = "DELETE FROM SFDC_New IN 'C:\Data\Foo.accdb';"
CurrentDb.Execute strSQL, dbFailOnError
Have a nice day!
That works great!