Access Modules

[shane01]

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

Shane

[DKenny]

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

[salvelinus]

Sub RunMySql()
Dim strSql As String

strSql = "DELETE * FROM tblFOO"
DoCmd.RunSql strSql
End Sub