Try This:
Create two objects in Access.
1. A Query that deletes the records from the table.
2. A Macro that runs the query.
In Excel VBA Editor:
1. add a reference to your version of Access.
2. Inset this code that will start a new instance of Access and run
the macro
Sub RunAccessQuery()
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.Visible = True
appAccess.DoCmd.SetWarnings False
appAccess.OpenAccessProject ("C:\Test.mdb")
appAccess.DoCmd.RunMacro ("MacroToDeleteRecordsWith89")
appAccess.DoCmd.SetWarnings True
appAccess.Quit
Set appAccess = Nothing
End Sub
I did not test code, so be sure to test on a test application.
Goshute