Access 97 used by multiple users

[JA]

Hello,

There is a 97 Access database, which is used by multiple employees. However,
some of the software is being upgraded to Office 2002. Consequently, there
is a problem when people with version 2002 want to open the Access 97
version. The database is not split either.

Possible solutions:

Split the database and create/distribute an MDE file.

Upsize database to SQL server and create/distribute an MDE file.

Are the solutions viable?



Thanks,

JA

 

[Alex White MCDBA MCSE]

It is possible to run Access 97 MDB's under Access 2002, requires some
fiddling with jet to work properly,
but with that said I would not share a front-end, so both of your solutions
are viable. Split the database and give different version front-ends to the
different users.

How much data have you got?

How many concurrent users have you got?

The move to SQL is a good idea for large databases with lots of users Access
97 supports databases up to 1GB all versions after that are 2GB, so even in
your worse case you are only going to be half way there. I love working with
SQL server as it is a great database but this may not be required in your
case, I always look at a 5 year plan with my programming efforts, are you
going to out grow 2GB of data within 5 years?

 

[Immanuel Sibero]

JA,

Split the database and create/distribute an MDE file.

Upsize database to SQL server and create/distribute an MDE file.

Are the solutions viable?

- Upsize to SQL is always good.

- I have an installation with 97 mdb Back End, and 97, 2000, 2003 Front
End's all linking to the 97 Back End. No problem.


Immanuel Sibero

 

[mehmet.aslan]

Hello,

There is a 97 Access database, which is used by multiple employees. However,
some of the software is being upgraded to Office 2002. Consequently, there
is a problem when people with version 2002 want to open the Access 97
version. The database is not split either.

Possible solutions:

Split the database and create/distribute an MDE file.

Upsize database to SQL server and create/distribute an MDE file.

Are the solutions viable?



Thanks,

JA