G
Guest
I have an Access 2003 database that is approaching 200 meg in size. It is
used by two different computers on a home network and is hosted by one of
them. Data changes by both users all day long.
Performance is slowing as the database gets larger. If I split the database
into front-end/back-end, I assume that performance will speed up. Or, I
could create a replica on the non-host computer and syncronize (several
times/day). Which is better, splitting database or replicating/synchronizing.
used by two different computers on a home network and is hosted by one of
them. Data changes by both users all day long.
Performance is slowing as the database gets larger. If I split the database
into front-end/back-end, I assume that performance will speed up. Or, I
could create a replica on the non-host computer and syncronize (several
times/day). Which is better, splitting database or replicating/synchronizing.