Re: ADP searches vs. MDB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Sat, 13 Aug 2005 14:40:10 -0400, "Sylvain Lafontaine" <sylvain aei ca (fill
the blanks, no spam please)> wrote:

>By default, ADP load into memory the first 10000 records for display and
>only these records are searched when using Ctrl-F. You should try searching
>a record which is not in the first 10000.
>
>MDB will load 100 records for display and then will load each subsequent
>record from the database until a match is found.

By the way, even though the ADP loads 10000 records into a recordset, it does
so 50 records at a time. If you search for a record that hasn't been loaded
yet, it just won't be found. This is frequently a problem when trying to move
to a specific row in the Open or Load event handler of a form.
.

Relevant Pages

  • RE: Exchange Log Files
    ... "Jasper Recto" wrote: ... W3SVC1 log file into excel and searching for a certain lines with a specific ... Is there a software than can load ALL log files at once and search through ...
    (microsoft.public.exchange.admin)
  • Re: How to set all nodes checked = false, on a treeview
    ... (I do have a routine to do that but searching for it has not worked ... If you want to set them to checked = false when you load them, ... >I need to set all nodes on a treeview so that checked=0 ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Multiple Sensoray cards with Windows Real Time Target
    ... so it is important to start searching around what does "rtwho" display after you load the driver without any slot number. ...
    (comp.soft-sys.matlab)
  • What is Visio searching for?
    ... it takes more than a minute to load with a 500K file size. ... It seems as though visio is searching for something on my network and if I turn my network off, it loads in less than 2 secs. ...
    (microsoft.public.visio.general)
  • FP98 will not recognize new files
    ... What I initally wanted to do, on my Compaq, was to load ... When installed It says that it is searching for ... going to this adress and then an error messsage appears ... You must have NT SUR 4.0 gold to install'. ...
    (microsoft.public.frontpage.client)