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.
They're just sharing from one front end. I would give each user their own frontend, but it's not possible given the network constraints. They wouldn't be able to link to the source. Is there a way to do this with a form? That would be just as good... as long as they can see the results of the query.
Perhaps populate the form from a recordset then disconnect the recordset from the table?
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.
They're just sharing from one front end. I would give each user their own frontend, but it's not possible given the network constraints. They wouldn't be able to link to the source. Is there a way to do this with a form? That would be just as good... as long as they can see the results of the query.
Perhaps populate the form from a recordset then disconnect the recordset from the table?
Thanks