Hi. I have an Access application which does lots of things by going
through some PINS in some large tables.
This application is installed on multiple computers, and works fine,
with one exception:
For reporting purposes, I need to keep a "central" table where each
application would save some data.
Currently I'm using a LINKED excel file named "SharedAccumulator" and
after each PIN successfully processed a record is added in the
"SharedAccumulator" table.
I'm experiencing occasional error 3343 (as in http://support.microsoft.com/kb/q238401/)
and 3734 (as in http://support.microsoft.com/kb/274211). I am using
Access 2000 and Excel 2000.
What could I do ? Use another approach, maybe ? Would saving to a
SQLServer db help (by using some stored procedures, maybe, with many-
many params (since my accumulator table has many-many fields).
Thank you very much.
Alex