No data display

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.
 
D

Dirk Goldgar

lava said:
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 ?
Click to expand...

I doubt it. If you post the code of the function, we may be able to
spot something. Have you tried setting a breakpoint and stepping
through the code?
 
Top