Tina Norris Fields
tinanfields at torchlake.com
Sun Feb 22 10:51:49 CST 2015
John, I'm not completely sure. But, the difficulty occurred between boxes running Win 98 and Win XP. Perhaps it was really only the NICs that were causing the problem. But, the playhouse setup was that the database resided on a Win XP machine and was being accessed by two other boxes, one was Win 98, the other was Win XP. This was not a split database, the whole database resided on the director's desk. The office assistant and the children's theater director had to access the database remotely over the network. All had been working well, I am told (I did not set this up, I inherited an existing setup). All of a sudden, one day, the database could not be opened. Upon examination, I learned that the database file was now a tiny fraction of what it had been. There appeared to be no data resident. Further investigation turned up reports from others that Access databases across networks between boxes with different OSs, were getting hosed. Then, there was that NIC that periodically broke the connection to run a self-check. Somebody else will know much more than I about this. We have now reached the limit of my understanding of the situation. :-) TNF Tina Norris Fields tinanfields-at-torchlake-dot-com 231-322-2787 On 2/21/2015 12:47 PM, John W. Colby wrote: > Interesting. What did the OS itself have to do with things? Did one > specific OS cause the disconnect during self check? > > John W. Colby > > On 2/21/2015 9:45 AM, Tina Norris Fields wrote: >> Absolutely - loss of connection while writing - go boom. Also, >> transmitting data between different OSs. That experience happened >> here a good ten years or more ago - Win 98 and Win XP and Win 2K >> machines sharing a database. Different kinds of NICs (at least one >> doing a self-check periodically, breaking connection for the >> self-check), different Oss, and the Access databases being used >> simply got fried. At the playhouse, it was one database. At a >> publishing house, it was five databases before the issue got figured >> out. >> TNF >> >> Tina Norris Fields >> tinanfields-at-torchlake-dot-com >> 231-322-2787 >> >> On 2/19/2015 4:06 PM, John W. Colby wrote: >>> 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 >>>