S
Sin
I have an Access database which runs a number or queries and export the
queries to a particular spreadsheet, in every export, the new results will
simply over-writes the existing results in particulars sheets in the xls
file. Everything works fine until we have mutliple user access.
What I found is that after another user runs the queries and exported the
result, then "any" user who have performed the same task before the new user
will encounter error 3190 when they tried to re-run the queries and export
the result (note that this problem will not occur to new user). i.e. only
repeated user accessing the db after a new user will encounter the problem.
And the problems lies in exporting the result to the spreadsheet.
The problem can be resolved by deleting the existing sheets in the xls file,
i.e. allowing the db to create new sheet in the xls file for the export,
however, I have quite a number of linked fomuleas in the xls file and would
like to avoid this path. Can anyone give me any recommandation on this?
queries to a particular spreadsheet, in every export, the new results will
simply over-writes the existing results in particulars sheets in the xls
file. Everything works fine until we have mutliple user access.
What I found is that after another user runs the queries and exported the
result, then "any" user who have performed the same task before the new user
will encounter error 3190 when they tried to re-run the queries and export
the result (note that this problem will not occur to new user). i.e. only
repeated user accessing the db after a new user will encounter the problem.
And the problems lies in exporting the result to the spreadsheet.
The problem can be resolved by deleting the existing sheets in the xls file,
i.e. allowing the db to create new sheet in the xls file for the export,
however, I have quite a number of linked fomuleas in the xls file and would
like to avoid this path. Can anyone give me any recommandation on this?