Scrolling through tables with odbc to sql server

P

phill hw

Hello all,

I have access 2000, sql server 2000. One table of data is stored on the
sql server and one table of data is stored in another access
database. Both tables are are accessed from another access database
using linked tables. Both tables contain roughly 1000 rows of data
The sql server is set to return a max of 10000 rows (defualt)


My problem is:
When open query containing the table of data from the linked access table,
all the data loads into the view and I can scroll through ALL of the
rows. When I do the same with the data on the sql server only some of the
rows are loaded and I have to let go of the scroll button before the
next batch of rows are loaded. Why do I have to keep letting go of the
scroll button. If create a form with a view inside, it will load all the
rows and let me scroll as expected. Why not in a query?

Does anyone know a work around?

PS I know its bad practice to play about it table and query views! Also
if I link to the sql server with a data project instead of an mdb this
effect does not occur. Access happliy loads all the rows.

Thanks in advance

Phill.
 
Top