Limit To Returned Records Via ESS?

[Teutonic_Night]

I have a solution that needs to update records in a MySQL database based on actions in the local FM database. I have the ESS connection set up, can see all the fields I need, etc. The problem seems to be that I can only retrieve 255 records at a time from the MySQL database. I'm using the MySQL ODBC drivers from MySQL on a Windows 2003 Server running FileMaker Server 9 Advanced. FileMaker knows how many records are in the MySQL table (~25k), but seems to only be able to access 255 at a time.

I haven't been able to find anything on FileMaker's site about such a limitation, so I'm wondering if it has something to do with the MySQL ODBC driver or perhaps the configuration of MySQL. Anyone have any suggestions or run into similar issues?

[mr_vodka]

This shouldnt be be the case. You should be able to view all the ESS records. Is this in its own dedicated layout?