I'm sorry, I posted this last week, but no one replied, and I really need a solution.
Whenever I open a report, if there is a form that is attached or using any of the tables that this report is using, I get an error of:
"The database engine could not lock table 'whatever' because it is already in use by another person or process"
I tried a bunch of things, but to no avail, I stilll have this problem. I tried separating my databse in two (tables/ everything else). Though I think it might be b/c I am generating the query from code. But I have done that elsewhere with no problem.
Thank you very much in advance for your help.
bauer
Whenever I open a report, if there is a form that is attached or using any of the tables that this report is using, I get an error of:
"The database engine could not lock table 'whatever' because it is already in use by another person or process"
I tried a bunch of things, but to no avail, I stilll have this problem. I tried separating my databse in two (tables/ everything else). Though I think it might be b/c I am generating the query from code. But I have done that elsewhere with no problem.
Thank you very much in advance for your help.
bauer