Linked tables in Access not fetching enough records 
Author Message
 Linked tables in Access not fetching enough records

I am sure that my dillema is an easy one for some but I cannot seem to
figure it out....

We have SQL 7 running on 256MB of ram and are attempting to access the data
using Access 97 using linked tables through ODBC.  The problem is that in
when we view the table it only fetches about 230 records at a time.  We
don't have this problem when viewing the data directly in the SQL tables
using the MMC.

We have tried various settings in the Access end to no avail.  I should also
note that when we try to access the data from a form in Access and use the
record arrows to move forward and back it goes in increments of 10...

If anyone has ANY thoughts on this issue your help would be much
appreciated..

Thanks

Mike Copenhaver




Tue, 18 Sep 2001 03:00:00 GMT
 Linked tables in Access not fetching enough records

To pull in all the records, tell Access to go to the last row of the
resultset.

In code the command is something like rs.MoveLast.

On the Access grid, hit the second button to the right after the row number
at the bottom of the grid form.



Tue, 18 Sep 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Fetch record into a plsql table (record.column_1 into table(index_1))

2. Performance problem in fetching record from table containg 2 million record

3. Oracle Linked MS Access Application not saving record changes

4. Not Enough Disk Space To Post Record

5. message: not enough disk space to post record

6. Deleted records when linking SQL Tables with Access 97

7. Accessing New Records in Linked Tables

8. Can not edit Tables linked to SQL through ACCESS

9. VBA in Access linked to SQL tables not working

10. Access linked Tables not remember password

11. Fetch is not returning first record?

12. Cursor does not fetch all records problem


 
Powered by phpBB® Forum Software