Hey there, Sorry for posting to this list, but I'm not so sure it's a myodbc problem exclusively. I am currently trying to get a mysql database to work with lotus approach. The plan is to port a current .dbf database over to mysql, and so far I have not had many problems. Until now. I am not sure if this is a myodbc problem or if it is a lotus approach ptoblem, but when i attempt to select all records from the database, a worksheet in approach will only display 80 records. I then change the MyODBC settings so that it will allow BIG results, with this set it will now display 240 records, but there are approx 890 records in the database, there seems to be some sort of limit on the number of records returned. This is very odd, and annoying, as I need to be able to view all records. Any help would be much appreciated. Conor --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php