I am developing an Access database in 2007 with a FE/BE configuration. I implemented a number of UI changes yesterday that worked just fine.... yesterday...
Today, in testing the very same UI I am receiving "Run-time error '3219" Invalid operation" on more than one line of code, and UIs that I did not touch yesterday. The line (>>>) below is one example, which I DID NOT CHANGE TODAY.
Thanks in advance.
Private Sub cmdAssignNo_Click()
Dim db As DAO.Database
Dim rst As DAO.Recordset, rst1 As DAO.Recordset
Set db = CurrentDb()
Set rst = db.OpenRecordset("assign Plan No", dbOpenTable)
>>> Set rst1 = db.OpenRecordset("tblPlan", dbOpenTable, dbPessimistic)