Data Corruption

[Charlie]

We are currently upgrading all users to Office 2003, however the database
keeps becoming corrupted on a 2003 machine. The set up is as follows:
The Design Master is on an Machine running Access 2002.
A replica is on the server for the users. A second replica is set at our
other branch.

At branch 1 there is 4 users running Office 2002 and 2 users running Office
2003. Following the resolution of missing references and compile errors, the
2003 versions all work well - however, when one of the 2003 machines opens
the database, it causes a corruption which can not be fixed with the repair
option - hence data has been lost.

It only happens when this one machine opens the database, the only
difference with this machine it that it is the only one running Windows 2000
where the others run Win XP

Branch 2 has had no problems but, then it is about to be upgraded to Office
2003 .

Any suggestions or advice would be appreciated

Charlie

 

[Charlie]

Hi Joseph,

All users are accessing the databse directly via 2 replications at each
branch. We are looking into splitting the database, but are looking into the
ins and outs of how it will work oner a VPN and a LAN network, as in will it
affect speed or will we need to keep it replicated and syncronize as we do
now.

Charlie

 

[Tony Toews]

All users are accessing the databse directly via 2 replications at each
branch.

Replication is only designed for tables and records. Not objects
such as forms, reports and modules.

We are looking into splitting the database,

This is a requirement for multiple users. As is giving each user
their own copy of the FE.

but are looking into the
ins and outs of how it will work oner a VPN and a LAN network, as in will it
affect speed or will we need to keep it replicated and syncronize as we do
now.

Using Access linked via a WAN to an Access backend MDB will only
guarantee you corruptions. As well as poor performance.

Thus in your scenario with multiple branches using replication of the
data would probably work reasonably well. And some other method of
distributing new FE's from the main server to the branches and then on
to the individual PCs is required.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm