Re: How much data that bound form fetch at a time ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Malee (malee_at_nospam.com)
Date: 09/24/04 

Date: Sat, 25 Sep 2004 02:56:48 +0700

> > I have question in mind that if database contains more than 1 million
> > records, How much data (records or KB or number of pages) that bound
form in
> > MDE and ADP fetch at a time ?

Uhmmm....Interesting Question . Have anyone know ? I also would like to
know.

Malee.

"MGFoster" <me@privacy.com> wrote in message
news:XD_4d.2106$zG1.1383@newsread3.news.pas.earthlink.net...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> The best way to reduce traffic is to only retrieve one record at a time.
> Create a Search form that allows the user to create the criteria that
> will select whichever record they want. The search form creates a
> statement (call to a Stored Procedure (SP) w/ parameters, or an SQL
> string) that will be placed in the working form's RecordSource. This
> will retrieve the desired record.
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQVR2eoechKqOuFEgEQKnzACg5/0byVBvQvaGhU5r8n9wdiSGY4wAn1RP
> FlGTS8wxeQkVSRYSIHnf/1tQ
> =Bpmm
> -----END PGP SIGNATURE-----
>
>
> suntisuka wrote:
>
> > I have question in mind that if database contains more than 1 million
> > records, How much data (records or KB or number of pages) that bound
form in
> > MDE and ADP fetch at a time ? I don't think MS Access XP will load all
> > records when bound form is opened. And Can I control MS Access the
amount of
> > data to be read at a time ? It will be great if I can control this
factor to
> > reduce the network traffic :-)
>

Relevant Pages

  • Re: criteria in a search query
    ... Hash: SHA1 ... You have to use a function to retrieve the variable value. ... The query: ...
    (microsoft.public.access.queries)
  • [Full-disclosure] Advisory 06/2005: Geeklog SQL Injection Vulnerability
    ... Hash: SHA1 ... Vendor Status: Vendor has released an updated version ... "Geeklog is a weblog powered by PHP and MySQL. ... With similiar strings it is possible to retrieve the complete ...
    (Full-Disclosure)
  • Re: virtue of salted passwords
    ... Password hashes can be retrieved in any number of ... > hash would also retrieve the salt at the same time. ... Any ideas as to how to make it harder to retrieve salts for web ...
    (alt.computer.security)
  • RE: Creating an HMAC for a string using a base64 encoded key
    ... // hHmacHash: ... goto ErrorExit; ... Call CryptCreateHash to retrieve a handle to a hash object. ... Call CryptGetHashParam again to retrieve the HMAC hash. ...
    (microsoft.public.platformsdk.security)
  • Re: How much data that bound form fetch at a time ?
    ... The best way to reduce traffic is to only retrieve one record at a time. ... Create a Search form that allows the user to create the criteria that ... > records when bound form is opened. ... It will be great if I can control this factor to ...
    (microsoft.public.access.adp.sqlserver)