Hi guys,
My database is accessed by several users. When the user opens my report it first makes a table of temporary data from one query, then uses another query on that table to populate my report. The problem is, when another user wants to view the same report, I get a table lock problem - presumably because my report is bound to the fields in the table which WOULD get overwritten whenever this report is run.
Does anyone have a way around this? I thought of populating the report from a recordset, then closing the connection. But I can't even get this to work!
Thanks
My database is accessed by several users. When the user opens my report it first makes a table of temporary data from one query, then uses another query on that table to populate my report. The problem is, when another user wants to view the same report, I get a table lock problem - presumably because my report is bound to the fields in the table which WOULD get overwritten whenever this report is run.
Does anyone have a way around this? I thought of populating the report from a recordset, then closing the connection. But I can't even get this to work!
Thanks