[AccessD] Word/Access question

Arthur Fuller fuller.artful at gmail.com
Tue May 29 18:53:53 CDT 2007


Preface: there are no stupid questions, only stupid people. Sadly, I fall
into this category.

I'm doing an Access app, for a WAN with issues (nuff said). It may
frequently occur that the remote users cannot, for one reason or another,
hit the DB residing at HQ. In this event, the client would like the remotes
to fill in a Word form and email it.

I'm imagining this app deployed as follows:

1. a local FE installed on every remote, all of which point to the BE
available by satellite, if and when the technology is working. Apparently
this is intermittent. I know nothing about this part of the app.

2. In the event that the satellite connection is unavailable, it has been
mandated that the remote user should be able to fill in a Word form and
email that. (Precisely how I am to handle said emails and integrate them
into the system has been conveniently overlooked, but like George Smiley, I
plod on.)

3. In the absence of a reliable connection to HQ, then I don't see how this
can work without a local copy of the DB. I am certainly not against that,
but it drags in the replication technology -- which I have used and love,
but it costs hours to set up and every time I mention hours Client says
"Cheaper", and when I mention "Cheap" Client says "Not enough
functionality", or something like that.

4. On the Up side, there is no danger of collision on rows from the remote
users. Each remoter has her own bailiwick and no other remoter will ever
touch (or even see) the contents of her bailiwick. So that part is cool.

I guess that I'm just wondering about the best way to handle this stuff
given a WAN whose connectivity is shaky at best. I have done some WAN stuff
previously, but connectivity was not a problem then. Now it is. I suppose
that replication may be an answer. I've been there and done that and I'm
pretty good at that approach, but that was then, and I had somehow assumed
that technology had got beyond what I did in 1998. Maybe not. Maybe that old
way is the way to go.

Arthur



More information about the AccessD mailing list