[AccessD] Backend database corruption

Loss of connection while writing to an Access DB is a known issue, never 
fixed, and probably unfixable.

Don't use Wifi / WAN with an Access BE.

The best option is to move the BE to a SQL Server BE.  That will 
absolutely solve this issue.  If you must continue to use Access as the 
BE, then write CSVs to a directory on the server and have an Access app 
RUNNING ON THE SERVER watch for these CSVs and import them into the 
table.  At least if the write to the CSV file is interrupted, it does 
not corrupt the BE.

John W. Colby

On 2/19/2015 3:01 PM, Janet Erbach wrote:
> Hello!
>
> It's been years since I've addressed this group, so please be patient with
> me while I get back into the swing of this.
>
> I've been an Access developer for the last 15 years or so.  Until recently
> I created straightforward apps used on a small group of hardwired networked
> computers that had 5 or 6 users in the app at the same time.
>
> Last year I took a job with a large manufacturing plant, and just deployed
> a very complex app that I co-wrote with one of the access-fluent production
> supervisors.  It is supposed to run non-stop on 20+ machines, all with WIFI
> connections.  It writes machine production data to a set of front-end
> tables;  every 15 minutes the app checks to see if there is network
> connectivity - if there is, the front-end table data is posted to the
> back-end tables on the network, the front-end tables are emptied, and the
> loop begins again.
>
> The app worked pretty well when it was running on one or two machines.  Now
> that it's up on 20 machines, the back end is corrupting multiple times
> during the day - which, of course, brings the whole show to a halt.  The
> error log seems to indicate that loss of a network connection during the
> back-end write operation proceeds the corruption.
>
> I have two questions.  Will hard wiring the network connection to these
> machines go a long way towards stopping the corruption?  Is there anything
> else that could be contributing to this that I need to be aware of?
>
> Thank you for your help.
>
> Janet Erbach