I created a simple find button on the access form. And I have a SQL server back end. Everything works well, adding, deleting records, etc.. Except when I use the "find" button" Sometimes it will work when I have the criteria set at "Whole field" and know there is a matching data in that field. Any other option such as "partial field" or if I search for a record that doesnt exist, it will just hang there. I can hit ctrl+break to break the search, but type ctrl+alt+delete brings up the task manager, saying MS Access is not responding. Anyone have any experience with this?
I get this hang-up sometimes as well even w/ its set as "whole field" & using data I know would match. Is there something I need to do at the sql server? This was a Access DB, and used the upgrade wizard for SQL. Im using Access 2000.