When querying a linked table, Access will return/load the entire table into Access before parsing the WHERE or HAVING clauses. At this point you can use the linked tables as you would any other native Access table. Thus far in this tips series on Access and SQL Server we have created an ODBC Data Source Name (DSN) using the OLEDB driver, created a System DSN for the new SNAC (SQL Native Client) driver and created linked tables in Access by using the SNAC DSN. By: Tim Ford | Updated: | Comments (31) | Related: More > Microsoft Access Integration
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |