By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,528 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,528 IT Pros & Developers. It's quick & easy.

Applyfilter or form bound to query??

P: n/a
Hi all
Ok here is the big question, have a form that was bound to a now large
database (Access 2002 client / server split) and I was accessing
various records based on using applyfilter. Now to me that became
ineffiecnt as I assume the client would request the entire dataset
over the LAN and apply the filter locally, is this true?
What I then tested was to bind the form to a query, that query has the
key referring to a hidden field on the form that I populate with the
key and then do a requery of the form, I assume this will then go to
the database and just get that one record. Is my assumption correct?
The users report the new option is slower than the first!!! So maybe
I'm just not barking up the right tree here. No chance to use SPROC's
just yet :(
Cheers
Shaun
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 16 Feb 2005 07:59:38 -0800, sh********@msn.com (Shaun) wrote:

Yes, filters are applied locally. But Access is often smart enough to
only pull the entire INDEX over the wire to make a local selection,
not the entire recordset. This assumes of course your db design is up
to snuff.

No, your assumption is not correct. Access is a stupid file-sharing
database. THere is no active process on the server doing work. The
only smarts is the Index thing I explained above. If you want a true
client/server database, use SQL Server or its cousins. MSDE may be an
option for small user loads.

-Tom.

Hi all
Ok here is the big question, have a form that was bound to a now large
database (Access 2002 client / server split) and I was accessing
various records based on using applyfilter. Now to me that became
ineffiecnt as I assume the client would request the entire dataset
over the LAN and apply the filter locally, is this true?
What I then tested was to bind the form to a query, that query has the
key referring to a hidden field on the form that I populate with the
key and then do a requery of the form, I assume this will then go to
the database and just get that one record. Is my assumption correct?
The users report the new option is slower than the first!!! So maybe
I'm just not barking up the right tree here. No chance to use SPROC's
just yet :(
Cheers
Shaun


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.