I am having the same problem in an Inventory DB.  I use SQL 2000 as the backend with an MS Access frontend on the users desktops that access this data. ...