I have a database that is on a scheduler. All it does is open up, update a few tables and then closes. I received an inexplicable error this morning so I ran a compact and repair....Fixed my original problem and now I have an even more perplexing problem. On the below code when it tries to execute the line in red I get a Run-time "Invalid bookmark" error . All of the forums I've found that pertain to this have some reference to a bookmark. As you can see I have no reference to a bookmark. Any suggestions?
Code:
Function funStoreDistrictRegion()
'On Error Resume Next
Dim mySQL As String
mySQL = "DELETE * FROM Store;"
CurrentDb.Execute mySQL
mySQL = "DELETE * FROM District;"
CurrentDb.Execute mySQL
'...Remaining code (Just a few more SQL statements)
End Function
I have tried running another compact & repair to no avail.