from the Seek Method topic in VBA Help:

"You can't use the Seek method on a linked table because you can't open
linked tables as table-type Recordset objects."

suggest you use the Find method instead. or, base the recordset on a SQL
statement that includes criteria to return the desired records only, instead
of basing the recordset directly on a table.

and btw, suggest you declare the recordset type as DAO.Recordset, rather
than simply Recordset.

hth


"Gerry" wrote in message
...
I have put my data tables into another access database which resides on a
server.
After splitting the database. When I use seek, it tells me that it is an
invalid function.
I have linked the tables in the backend database to the current database.
my code is as follows :

Dim dbs1 As dao.Database
Dim rst1 As Recordset

Set dbs1 = CurrentDb
Set rst1 = dbs1.OpenRecordset("Customer Forecast")

rst1.Index = "Key"
rst1.Seek "=", estkey

before splitting the database, it worked fine. Why would this stop
working.
The table in the backend database is indexed on "Key"

Thank you,
Gerry