I have the following code that puts an ID into a field in the table tblPSX.
Dim db As Database
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("tblPSX", dbOpenTable)
'Updating the records
Do Until rs.EOF = True
Set rs = Nothing
Set db = Nothing
The code works fine if tblPSX is not a linked table, but if the table is linked I get the following message:
Run-time error '3219': Invalid operation
When I debug, the highlighted text is "Set rs = CurrentDb.OpenRecordset("tblPSX", dbOpenTable)".
Can anyone help?