AshikHusein
Registered User.
- Local time
- Today, 14:01
- Joined
- Feb 7, 2003
- Messages
- 147
I have a general quetion about ntwork traffic with reference to ACCESS.
If I have a BE/FE split setup with linked Access tables and if an FE opens a recordset ( as in DAO.Recordset or ADODB.Recordset), what is the process that ACCESS follows:
Does it first send the whole table over the network and then filters the table as per SQL statement of the recordset being created, after which it destroys the table from the computers memory leaving only the recordset in memory
OR
only the recordset, filtered as per the SQL statement, comes into the memory of the local computer?
Also, are the linkd tables in every FE just pointers to the tables in the BE or are they active connections which add to network traffic. My knowledge of networks is less than elemntary so please excuse me if something is not sounding right here.
The BE is also ACCESS. Thank you.
If I have a BE/FE split setup with linked Access tables and if an FE opens a recordset ( as in DAO.Recordset or ADODB.Recordset), what is the process that ACCESS follows:
Does it first send the whole table over the network and then filters the table as per SQL statement of the recordset being created, after which it destroys the table from the computers memory leaving only the recordset in memory
OR
only the recordset, filtered as per the SQL statement, comes into the memory of the local computer?
Also, are the linkd tables in every FE just pointers to the tables in the BE or are they active connections which add to network traffic. My knowledge of networks is less than elemntary so please excuse me if something is not sounding right here.
The BE is also ACCESS. Thank you.