I have a rather large db that i've split. In my backend I've just started having problems, never had them before. On certian reports (scrolling through view) I keep getting an error msg that you can't do anything because another user is attempting to change the same data, however there are no other users in the db. I've compacted and repaired each user's front end and had them re-boot the machines and I still get the error. I've tried to compact and repair the backend and It only goes about 1/3 of the way and the db comes back up but it creates 2 copies.
I've rebuilt the report and query and still no success.... any ideas?