473,320 Members | 1,828 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

"Accumulator" table for multiple computers WITHOUT concurrencyproblems

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
Jul 27 '08 #1
2 2045
On Sun, 27 Jul 2008 16:53:26 -0700 (PDT), Radu
<cu*************@yahoo.comwrote:

Excel is a poor choice because it is not great with locking
strategies. Why not use an Access table? You are already using Access
anyway.
When adding (or updating, for that matter) a record in a multi-user
environment there always is a chance of a write conflict. That is
normal. You should be able to deal with that with a good error
handler. For example one that in a loop silently goes to sleep for an
increasing amount of time and retries (using Resume), until successful
or a set amount of time is expired. Only then would the user get the
error message.

-Tom.
Microsoft Access MVP
>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
Jul 28 '08 #2
What are "PINS"?

Thanks,

Steve

"Radu" <cu*************@yahoo.comwrote in message
news:ab**********************************@d77g2000 hsb.googlegroups.com...
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

Jul 28 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Jordan Rastrick | last post by:
First, a disclaimer. I am a second year Maths and Computer Science undergraduate, and this is my first time ever on Usenet (I guess I'm part of the http generation). On top of that, I have been...
12
by: Georg Brandl | last post by:
Hello, in follow-up to the recent "dictionary accumulator" thread, I wrote a little module with several subclassed dicts. Comments (e.g. makes it sense to use super), corrections, etc.? Is...
11
by: L. Chen | last post by:
The standard says that a char* or void* pointer has the least strict alignment. But I do not know what is a strict alignment. What does that mean?
21
by: Helge Jensen | last post by:
I've got some data that has Set structure, that is membership, insert and delete is fast (O(1), hashing). I can't find a System.Collections interface that matches the operations naturally offered...
6
by: HappyHippy | last post by:
More of a minor niggle than anything but how would I remove the aforementioned space? eg. strName = 'World' print 'Hello', strName, ', how are you today?' comes out as "Hello World , how are...
27
by: comp.lang.tcl | last post by:
My TCL proc, XML_GET_ALL_ELEMENT_ATTRS, is supposed to convert an XML file into a TCL list as follows: attr1 {val1} attr2 {val2} ... attrN {valN} This is the TCL code that does this: set...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.