How do I open a linked table?

[kwokv616]

If a table is imported into the database, we write:
Dim rst_p, rst_r As DAO.Recordset
Set db = CurrentDb
Set rst_p = db.OpenRecordset("Pol", dbOpenTable)
Set rst_r = db.OpenRecordset("Rid", dbOpenTable)
But if the tables are linked instead, what code should i write to open it?

Thank you very much!

 

[Dennisk]

same code just change the table name

 

[namliam]

Dim rst_p, rst_r As DAO.Recordset

should actually be:
Dim rst_p as DAO.Recordset, rst_r As DAO.Recordset
Very important!

 

[kwokv616]

Hi, Thank you.
But what do u mean by change the file name?
my files to be opened are "Rid" and "Pol"

The problem i have is it says "Invalid operation" when i run the code, and it highlights the line Set rst_p = db.OpenRecordset("Pol", dbOpenTable).

i dont know what has gone wrong...=(

 

[namliam]

You cannot use dbOpenTable on a linked table...

remove that... you will be fine, except using "Seek" and indexes will cause problems.