Quote:
Originally Posted by 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!
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
