Issue with Linked Table

[Steve Haack]

Can someone tell me why the followig works if the tblPlayers is local, but
not when it is linked?

dim db as DAO.Recordset
dim rst as DAO.Recordset
set db=CurrentDb
set rst=db.OpenRecordset("tblPlayers")
rst.Index="PlayerID"
....

If tblPlayers is local, no issues. When I split the database to front
end/back end, then the code will stop at the "rst.Index" statement and I get
a 3251 Runtime Error: "operation is not supported for this type of object"

Thanks,
Steve

 

[Daniel Pineault]

Index and Seek do not work with linked tables. There is however a solution.
Take a look at:

http://www.mvps.org/access/tables/tbl0006.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.