I am using Access Data Project 2002 as the front end for a SQL Server 2000 database. Occasionally, a form will get stuck on a particular record and refuse to go to another record.
I've found that when this happens, it is because the Server Filter has been set to the record the form is stuck on. Deleting this (i.e. setting Server Filter to blank) removes the problem, but it always comes back a few days or weeks later, and always with a different record.
Anyone know why this is happening, and what can fix it?