Run-Time 3251 on Linked table

[Pete]

I recently split by .mdb in to front-end back-end operation. However,
I now recieve a 3251 error on the ".index" line of the following code.

DIM glbRoster as DAO.Recordset
Set glbRoster = CurrentDb.OpenRecordset("Roster")
glbRoster.Index = "MbrNumberKey"

When I run the backup code, taken at the time of the split, the code
works correctly. There have been no changes applied to the code.

Any ideas?

 

[Guest]

I'm not an expert on access, but I would guess that your receiving that error
because you are no longer pulling information from the "CurrentDb". Because
you have split the database, you will need to revise your code to access an
external database (ie. your backend).

 

[Van T. Dinh]

Yuo cannot use Index / Seek on linked Table. I normally replace Seek with
FindFirst.

Alternatively, see The Access Web article:

http://www.mvps.org/access/tables/tbl0006.htm