C
Charles Coltun
I have noticed that the technique of retrieving a record
in the underlying data table up to a form (for which the
data table is the record source) is slow. I find this to
be the case when the data resides on a server with token
ring topology. Yet, when I move the data to a local
computer's hard drive, the record requested comes up at a
respectable speed. I understand (from the Microsoft
online help system) that the Recordsetclone.Findfirst
technique results in a sequential search, which over the
network can result in a painfully slow response. This
same sequential search technique speed up dramatically
when the program and data reside on a local computer's
hard drive.
I have had to resort to doing a Filter by Form. I
understand (from the Microsoft online documentation) that
Filter by Form is an indexed search technique. This
technique works very well over the network.
Are there any indexed search techniques that I can use
with the recordset.find commands on a form. I have
attempted to use recordsetclone.seek, however, setting the
recordsetclone.bookmart to the form's bookmard resulted in
an error message.
Any assistance would be greatfully appreciated.
Thank you,
Charles Coltun
in the underlying data table up to a form (for which the
data table is the record source) is slow. I find this to
be the case when the data resides on a server with token
ring topology. Yet, when I move the data to a local
computer's hard drive, the record requested comes up at a
respectable speed. I understand (from the Microsoft
online help system) that the Recordsetclone.Findfirst
technique results in a sequential search, which over the
network can result in a painfully slow response. This
same sequential search technique speed up dramatically
when the program and data reside on a local computer's
hard drive.
I have had to resort to doing a Filter by Form. I
understand (from the Microsoft online documentation) that
Filter by Form is an indexed search technique. This
technique works very well over the network.
Are there any indexed search techniques that I can use
with the recordset.find commands on a form. I have
attempted to use recordsetclone.seek, however, setting the
recordsetclone.bookmart to the form's bookmard resulted in
an error message.
Any assistance would be greatfully appreciated.
Thank you,
Charles Coltun