Access Modules

How can I use a Microsoft Access Module to run an SQL Update or DELETE statement on a table in the database?

Shane

Search this forum for ADO and Access. That should give you some pointers.

VB Code:

Sub RunMySql()
   Dim strSql As String
 
   strSql = "DELETE * FROM tblFOO"
   DoCmd.RunSql strSql
End Sub