MSAccess (2003) Splitting a Database is it just for LANs?

[Laurie B.]

We have a database in our Parsippany, NJ office and need to have a user in
our Phildelphia office and Boston office update the database. Can we split
the database and link the database to these two other locations?

LaurieB.

 

[Arvin Meyer [MVP]]

No, I would not advise that for 2 reasons:

1. A file server database running over a WAN is so slow as to be basically
unusable.

2. The Internet often drops packets. For small files, it's not much of a
problem. For large files like Access databases, it can easily lead to
corruption.

My suggestion is to use a thin client, like Terminal Services, or even RDP
if there is only one person accessing at a time. That solves both problems.
You still need to split the database, because 2 users should NEVER share a
front-end. On a terminal server, just put a copy of the front-end in a
folder for each user.

 

[Laurie B.]

Arvin,

Thank you. I will have to open a service ticket with IT to discuss this
with them.
LaurieB.