Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rparkhouse
Starting Member
1 Post |
 Posted - 2011-08-01 : 04:24:54
|
| When MSAccess uses a network SQL Server database using linked tables, where is the result set held when for example a form bound to a large table is opened. Is the result set held on the SQL Server and sent to the MSAccess client machine as the user pages through the records or are large parts of the result set sent to client and Access manages the delivery?When bound forms are used, does this mean SQL server holds locks on all the rows until the form is closed?Thanks |
|
|
|
|
|
MSAccess and SQL Server database