I have ado code that connects my program to access(2000) database. The records in the table linked are 1000+.

In the vb form, only 993 records are returned. But the report(Crystal Report) shows all the records.

Does Ado have a limit to records that can loaded?

If not, what could be the problem?