asked on

Using Seek on Linked table...

Access 2003

I'am trying to open a database and then open a recordset that is the linked table....

I'am using the seek method...

I don't think I have my references set correctly....
Do I need a specifc reference for this ..

' for Linked Table XrefInfo 08/06/2007
Dim dbBE As Database
Dim strBEPath As String
strBEPath = Mid(CurrentDb.TableDefs( _
"tblXrefInfo").Connect, 11)
Set dbBE = OpenDatabse(strBEPath)
' ================================================
Set qd = CurrentDb.QueryDefs("qryBruteForceResultMfrnum")
Set dbs = CurrentDb
'=================================
' DECLARE RECORDSET
Set rsCust = CurrentDb.OpenRecordset("tblMfrnumDescMatch")
Set rsMfrnum = CurrentDb.OpenRecordset("tblXrefInfo", dbOpenTable) ' Xref Information

ASKER CERTIFIED SOLUTION

jadedata

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jadedata

don't forget to set your index for use also...

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

From the Help File - you cannot use Seek on a Linked Table

"You can't use the Seek method on a linked table because you can't open linked tables as table-type Recordset objects. However, if you use the OpenDatabase method to directly open an installable ISAM (non-ODBC) database, you can use Seek on tables in that database."

mx

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Sorry ... hit Submit by accident.

Clarification .... You can open tables (not linked) in an external database and then use Seek.

mx