I need to add a new field to one of my tables, but when I try to enter design view it's complaining that a query or form bound to the table is open, or another user has the table open.
I know that when you try to compact and repair the DB while someone else is in it, it will show you the user and machine name causing the problem. When I did that, it showed me. I've tried rebooting, made sure nothing else was open, deleting the lockfiles (did not work btw, file may be in use error), etc.
I'm positive Im the only one using it right now, how can I fix this problem?