[dba-SQLServer] Continuous Forms and Filters

I am curious.  My understanding is that when a filter is applied this way,
all the records are brought across and the filtering is done by Access, not
at the SQL end.  Is this correct?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Gary Miller
Sent: Friday, 25 April 2014 6:44 p.m.
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] Continuous Forms and Filters

Glad it did the trick. I link the tables/views through ODBC connections but
then don't populate the forms until I have a thin recordset to call.
Efficient enough for the scale I'm working with even over the internet to
desktops.

Gary

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of David
Emerson
Sent: Thursday, April 24, 2014 7:26 PM
To: 'Discussion concerning MS SQL Server'
Subject: Re: [dba-SQLServer] Continuous Forms and Filters

Thanks to Gary for his help,  the solution was to use linked tables or views
and not a stored procedure.

David