B
Bill Sturdevant
I have an MDB FE and have just converted my BE to SQL Server. When the first
screen opens, in the pure Access method, I referenced the table and applied a
filter to limit the records, then used the record navigator buttons to go
First, Next, Prev, Last.
With a SQL Server BE, this method retrieves far too much data and is too
slow. I would like to somehow be able to "attach" to a view of the data
(which would allow me to sort and filter), and then create my own First,
Next, Prev and Last buttons, and retrieve only one record at a time.
What is the best method to do this. I know I could create some sort of
record locator palette, and then have the user choose the desired record and
retrieve only tht one. But, my first choice is substitute my own navigation
buttons without a locator pallette.
screen opens, in the pure Access method, I referenced the table and applied a
filter to limit the records, then used the record navigator buttons to go
First, Next, Prev, Last.
With a SQL Server BE, this method retrieves far too much data and is too
slow. I would like to somehow be able to "attach" to a view of the data
(which would allow me to sort and filter), and then create my own First,
Next, Prev and Last buttons, and retrieve only one record at a time.
What is the best method to do this. I know I could create some sort of
record locator palette, and then have the user choose the desired record and
retrieve only tht one. But, my first choice is substitute my own navigation
buttons without a locator pallette.