PDA

View Full Version : Solved: Table conflict


ailyn
11-15-2005, 01:09 AM
I've got a form that feeds on a table, from that form I'm trying to open a report that feeds on the same table, but it gives me an error that says that another user or process is already using that table. this system works for my other tables. Any idea what could be causing the problem?
OBP
11-16-2005, 06:19 AM
Has this form got "record locking" on?
Have you tried using a query to supply the form and a seperate query to supply the report?
ailyn
11-16-2005, 08:35 AM
The record locking is off and they don't have separate queries. is that the problem?
ailyn
11-22-2005, 01:29 AM
I expressely made different queries and they don't work either. Actually I have 5 tables and this problem is present on three of them. I cannot open their reports from the form (the button is not the problem). When I open the form and then the report from the Access menu I get the same error. but when I open the report and then the form they both work http://vbaexpress.com/forum/images/smilies/banghead.gif
I'm completely lost here. HELP PLEASE!http://vbaexpress.com/forum/images/smilies/pray2.gif
GaryB
11-23-2005, 03:52 PM
Hi Ailyn,

I ran into this problem a while back. What I did, and for some reason it seemed to work, was make a query that controlled the form and then made a copy of that query and renamed it yournamereportquery and used it to control the report and it stopped the problem, for me anyway. (same thing stated above by OBP) But using the same query renamed is what did the trick. I honestly can't say why that made a difference, but it did. When you do this, you will have to go into the form and change the source for the data from the table to the query you are using for the form. Hope this helps.

Happy Thanksgiving,

Gary
ailyn
11-24-2005, 02:20 AM
Thanks a lot, Gary!
But I already tried that a while ago without any results. Fortunately, yesterday I googled and googled until I found someone mentioning the Record Locks option in the reports.
So I changed my reports from record locks: all records to no record & it showed! Now everything seems to work nicely although I still have to test it with more records, but I think the problem is solved. THANKS a lot for your help anywayhttp://vbaexpress.com/forum/images/smilies/clap.gif
& a very Happy Thanksgiving to you too!!!http://vbaexpress.com/forum/images/smilies/cloud9.gif