Converson in a mixed environment HELP!!!

[Dave Engeldinger]

I have a database designed in Access 2000 running in a
multiuser (5 Users) environment. 2 systems are win 98, 3
systems are win 2k. All of the systems are running Office
2k Pro. they are connected on a peer to peer network. The
Database worked flawless (imaging that).

Then two of the bone heads had to go and get new systems
each is win 2k but one is now Office 2002 and the other
went and changed to Office 2003.

At the same time they added a Win Xp machine with Office
2003. and the database was copied from one of the Win 2k
Office 2K machines to the new XP Office 03 system

I started to get an error that says the database needs to
be repaired, when I click on repair I recieved an invalid
password message. I researched the knowledge base and
found that Jet Comp fixed it. After about the 3rd time of
this happining I again copied the database back to a Win
2k Office 2k machine. It went months with out issues but
now It's back.

Any ideas?

 

[GVaught]

If it makes you feel any better their are boneheads in everyone's office.
Many workers and even network admin's don't even consider the repercussions
when upgrading an Office application, partially upgrading some users, moving
a database to a new machine, and then wonder why their database fails. At
least you seem to have that concept down. However I must ask and I apologize
if I insult your intelligence.

Is your database split into a Back-end/Front-end? If not this could be the
problem. Anytime a database is going to be shared it should be split.
Backend resides on a non-workstation machine and the Front-end reside on
each user's machine. This will help with multi-version application. Also,
another thing to check is the permissions with the new user's. All user's
must have not only read/write/modify/change permissions at the shared level,
if you have the machine formatted NTFS you must have the appropriate NT
permissions also. You do mention peer-to-peer, however you didn't mention if
the Win 2k system is formatted at the FAT level or if NTFS level?

Please pass onto your client/boss that Access 2003 still has a lot of issues
and should not upgrade to that version yet. If he/she orders new machines,
request Office 2002, if 2000 can't be ordered.