I have created multiple instances of the ASPRunner with different Access database fields included in the list page. Regardless of what order I place the fields in, the Equipment ID field which is my Primary Key Field in the Access Database does not search properly. When I search for known equipment ID numbers ASPRunner either returns no results or returns all of the records.
The field is a 50 character text field in an Access 2003 database and contains 4838 records that have alph-numeric equipment numbers. All of the other fields that are included in the ASPRunner form search properly and all other functions work properly.
Any suggestions to fix this problem would be appreciated.
Thanks!