Differences between normal and Linked Tables There are two main differences between a table that is actually in the current database, and a table that is just linked to the database. Firstly, if you are opening a Recordset based on a linked table, then you will probably need to change the type of Recordset that you are using. If you are using a Table in the current database, then you can use: Set rs=DBEngine(0)(0).OpenRecordSet("tblName",dbOpenTable) On a linked Table, you can't use this. You can either leave the argument blank, and let Access work out the type of Recordset to use (with a slight performance loss), or else specify the type, which would be dbOpenDynaset: Set rs=DBEngine(0)(0).OpenRecordSet("tblName",dbOpenDynaset) The other major difference is between the two types of Tables is that the Seek method is not directly supported on a linked Table (although you can work round this limitation by opening another Database object in the current Workspace), and you will have to use FindFirst instead. Top   HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES E-MAIL Copyright & Disclaimer

Last modified at 06/06/2006 15:00:30