Data Corruption

[Guest]

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

 

[Joseph Meehan]

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

Are users accessing the database directly or are they using a split
database and accessing it via a front end file on their individual computer?

 

[Guest]

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

 

[Joseph Meehan]

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.

I believe you are asking for problems until you split the database.
Really it is the way to go. It should work fine with a good LAN, I can't
say about VPN, but I understand there are problems accessing Access there
and it is a problem if you do it directly or using a split system.

 

[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