Running database on differing OS machines

[Stinky Pete]

Hi,

I've got two users needing to look at the same database, but both are
running differnent versions of access. One is running running Win 98 /
Access 97 and the other is running Win XP / Access 2003. I've converted the
file to 97 format so both can use it - but is there a better way to do this
and not mess with the original version? Obviously ugrading would a good,
but I'm not going to get approval to change until a new PC is purchased.

Stinky ;-)

[bruce]

Stinky Pete wrote:

Hi,

I've got two users needing to look at the same database, but both are running differnent versions of access. One is running running Win 98 / Access 97 and the other is running Win XP / Access 2003. I've converted the file to 97 format so both can use it - but is there a better way to do this and not mess with the original version? Obviously ugrading would a good, but I'm not going to get approval to change until a new PC is

purchased.

Other than splitting the database into a front-end 'application'
database (containing all your forms, reports, queries, modules, etc.)
and back-end 'data' database (containing only your tables) there's not
much else you can do. If your database is split you can install Access
97 on the Win XP machine (either concurrently or remove Access 2003)
and at least keep both front-ends in the same version of Access which
might be easier to maintain. Your back-end will have to remain in
Access 97 until you can upgrade the Win98 machine.

Bruce