Too many records

  • Thread starter Thread starter lava
  • Start date Start date
L

lava

I am trying to open a recordset in Access for a linked sql
server table. As soon as I open it I am doing a
Recordser.Movelast to get a record count. But the Function
seems to quit without any error message and not going
through the statements after the OpenRecordset function.
Could it because of the the table has 6000 entries and it
is not able to read through all of them before the
Movelast command ?
Thanks in advance for any help.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No data display 1
Can I get a record count of this??? 1
No current record 4
Can I get a record count of this??? 2
"too few parameters expected" when filtering OpenRecordset 2
Record Count 12
DAO select 2
Determing the Number of Records in an Append Query 3

Back
Top