Couldn't lock table

[goaksmith]

I have a database with two front ends and one back end. Up until yesterday this was working fine. Both front ends have tables, queries, forms, reports, and macros. Yesterday, front end A worked fine. And everything on front end B worked find EXCEPT for the a certain form. Everytime anyone opens this form they get the message

"Couldn't lock table 'Cr DDA Table' (a table withinin the database); currently in use by user 'Admin' on machine 'Cxxxxx' (their computer number)"

And the form will not open. I stayed after yesterday to see if I could fix this problem and when I did it opened fine. Now, at this point in time no one was using either front end. So obviously since there was no one in the database there was no one to lock it so it opened. The table itself is hidden and no one but myself can see it. So basically my question is why am I getting this error? And what can I do to make it stop occuring?

 

[Rob.Mills]

I'm not totally sure of the answer but could it possibly be that you as the admin have the table open exclusively. I don't know if you can open an object that way like you can a whole database. Hope that helps.

 

[goaksmith]

I would say that someone could have that table open which is causing a problem. However, the table is hidden and the only computer it can be seen on is my own. And even if my computer does not have the application open people get the same error message.

 

[Rob.Mills]

Well even if someone can't see the table, if they open a form that's tied to the table and are somehow opening it exclusively that could cause problems. I'm not saying that's the case here because like I said I'm grasping here.

 

[colmtourque]

the only time I see this sort of problem is when I am editing the DB, even if I am not touching the specific portion.
Best guess also though, sorry.