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.OpenRecordse t("Pol", dbOpenTable)
Set rst_r = db.OpenRecordse t("Rid", dbOpenTable)
But if the tables are linked instead, what code should i write to open it?

Thank you very much!

[ChipR]

The code doesn't change at all.

[MikeTheBike]

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.OpenRecordse t("Pol", dbOpenTable)
Set rst_r = db.OpenRecordse t("Rid", dbOpenTable)
But if the tables are linked instead, what code should i write to open it?

Thank you very much!

Hi

I find that if you omit the dbOpenTable 'Type' argument then it works OK, In fact only 3 of the 5 'Type' arguments seem to work with a link table name.

I cannot comment further as I only use ADO recordset (at least for the last 8 years!).


MTB