I am puzzled by the behavior of this code I am trying to udpate.
I wanted to split the database and have a backend with all the tables.
This code will not run after I moved the table to the BE. I get an "invalid operation" error
I worked on it and thought I had it and changed the recordset to dynaset instead of table but then I get a new error "the operation is not supported"
so how do I fix this to work on a BE? Help appreciated. Using Access 2003
Dim strReqName As String
Dim strContName As String
Dim strReqType As String
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim rstReqName As DAO.Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("tblRequestor", dbOpenTable)
You can't use the Seek method on a linked table because you can't open linked tables as table-type Recordset objects. However, if you use the OpenDatabase method to directly open an installable ISAM (non-ODBC) database, you can use Seek on tables in that database.
I would go further and drop that method altogether. Why open a recordset on an entire table when you just want one record? Open it on an SQL string instead, with a WHERE clause that pulls that one record.