Stuart McLachlan
stuart at lexacorp.com.pg
Fri Oct 3 01:25:23 CDT 2003
On 3 Oct 2003 at 7:23, Liam Meadows wrote: > Hi All > Just a quick Question, Am I right in thinking that if you use an Access > MDB with FE/BE over a network the Front End has to pull the Back End > over to the local machine then action it ? > If so does an SQL Server ODBC Back End Behave in the same way ? > It behaves the same way if you just link the tables and manipulate the data in your front end using standard queries, recordsets etc The big advantage of SQL Server is that you can use Views and Stored Procedures. In that case, the work is done by the BE and all that gets sent over the network is the result set -- Stuart McLachlan Lexacorp Ltd Application Development, IT Consultancy http://www.lexacorp.com.pg