.Seek or .Find record with SQL Server

[Lynn Pennington]

Looking in the Microsoft Knowledge Base - this is not
supported in a MDB file. Moving to an Access project is
not an option.

How do I SEEK or FIND a record in SQL linked tables?

Thanks,
Lynn.

 

[Alex Dybenko]

use select SQL statement, better in a path-through query

 

[Tim Ferguson]

How do I SEEK or FIND a record in SQL linked tables?

You don't. These methods were included in Access as hangovers from old
file-management programs like dBase and are not part of the normal RDBMS
toolkit. SQL server in particular is set up to respond to database commands
like ORDER BY and WHERE.

Hope that helps



Tim F