In addition to the advice you've already gotten, take a look at
http://www.mvps.org/access/tables/tbl0006.htm at "The Access Web" for how
you can continue to use Seek (although there's really no reason to)
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"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