Janet Erbach
jerbach.db at gmail.com
Mon Feb 23 09:01:50 CST 2015
:) On Sun, Feb 22, 2015 at 5:41 PM, Jim Lawrence <accessd at shaw.ca> wrote: > Hi Janet: > > I am not ignoring you, it is that I will have to dig up some samples to > show you that may be helpful. > > Jim > > ----- Original Message ----- > From: "Janet Erbach" <jerbach.db at gmail.com> > To: "Access Developers discussion and problem solving" < > accessd at databaseadvisors.com> > Sent: Friday, February 20, 2015 2:22:46 PM > Subject: Re: [AccessD] Backend database corruption > > Jim - > > I would, indeed like to learn more. All of my connections are DAO... > > Thank you! > > On Fri, Feb 20, 2015 at 1:49 PM, Jim Lawrence <accessd at shaw.ca> wrote: > > > Hi Janet: > > > > Nice to hear from you...is this too late for comment? Assuming no, let me > > add to the discussion. > > > > Most people on this list have heard me preach on the topic more often > that > > not. To start with, on any major applications, developed in Access, I for > > one, would and never used DAO data connection. As all of you pointed out > it > > is just too unstable, especially in a heavy work environment. > > > > You can use ADO. The protocol is on all Windows from Win95 to Win8.x and > I > > believe on Win10, but I haven't checked yet. It is rugged, fast and > > completely recoverable from. It matters not how large, distributed or > > complex the application is. > > > > If you want to learn more or want help just ask. > > > > Jim > > > > ----- Original Message ----- > > From: "Janet Erbach" <jerbach.db at gmail.com> > > To: "Access Developers discussion and problem solving" < > > accessd at databaseadvisors.com> > > Sent: Friday, February 20, 2015 11:01:24 AM > > Subject: Re: [AccessD] Backend database corruption > > > > THANK YOU ALL for your responses - this is all very helpful. I'm going > to > > push for hard wiring all of the connections as soon as possible; I also > > like the idea of logging when the write operations are happening to see > how > > much overlapping traffic there is. > > > > I think the CSV approach is very interesting too, and will bring that up > in > > a meeting next week along with presenting the SQL backend option. I > think > > we would try the CSV approach first. It would be difficult to convert to > a > > SQL backend, I think, on the 20 hours a week that they've alotted > > me...especially since more than half of that time is via remote > connection. > > > > Again - thank you all. I am much relieved to have a few options to > pursue! > > > > > > > > On Thu, Feb 19, 2015 at 4:25 PM, Darryl Collins < > > darryl at whittleconsulting.com.au> wrote: > > > > > Yes. John is spot on. These would be my primary solutions to this > issue > > > as well. > > > > > > Cheers > > > Darryl. > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com [mailto: > > > accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby > > > Sent: Friday, 20 February 2015 8:06 AM > > > To: Access Developers discussion and problem solving > > > Subject: Re: [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 > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >