I've been working on code to search a database and display the results in a table. For development purposes, I created a test database with 25 records and thoroughly tested my code, which did everything required of it. I then satisfactorily uploaded three pre-existing databases with sizes ranging from about 250 records to about 1100 records. The tables created appear to be complete and correct in every respect.
On changing all the applicable variables in my code, I found that only the first 50 records of the new tables was being searched. I might have overlooked something, but I can find no reason why this is happening. Searching with a null-string yields the first 50 records in the table, and searches correctly within those 50 records, but ignores the remainder.
Can the limit be set somewhere, or have I missed something obvious?
Any assistance would be appreciated.