Greetings Liz,
Have worked with Networked Access DB's for 18 years. Loosing connection due to and Network Issue can corrupt your DB, especially if using the Single DB model. If you split the data from the Code, the likelihood of corruption is diminished substantially. Distribute your Code modules to each client, if possible.
Further, if you design using Static Copies of the data unless performing changes (use short Transactions) , the DB becomes very stable. It requires more work when designing, but the payoff is worth it.
That said, Access has gone thru a number of updates which has improved the ability to recover from a lost connection. The DB can 'crash' and recover. But my rule of thumb from the 'early days' is ALWAYS keep a backup.
Good luck,
7ony
On Thursday, January 30, 2014 10:34 AM, "wrmosca@comcast.net" <wrmosca@comcast.net> wrote:
Hi Liz
LANs are usually pretty good because of the better connection. WANs can be tricky if the connection is not solid. This is the best argument for a split DB with the front end local. But all this is just from what I've picked up second-hand.
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote:
Anyone have any information regarding semi-technical pros and cons on running Access in LAN vs. WAN and particularly the issues or non-issues with running it from Citrix?
Doing a little homework here…
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 |
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar