Converting from MS Access97 to 2000

[Barry Connolly]

I need to have a database file (mdb) available to MS
Access 97 and MS Access 2000. What are the major issues
sharing the file between the two versions?

Barry

 

[GVaught]

It can be done, but it is easier if everyone is on the same sheet of music.

Split the database. The backend should remain at the 97 level and reside on
a server type machine; preferably an NT server such as NT4, Win 2K
server/2003 server. The back-end can reside on Win 2K pro or XP pro, however
you are restricted to 10 users. The front-ends can be either version and
reside on the user's machine. All users must have read/write/change/modify
type permissions on the database and folder location where the database
resides.

Those with 2000 may be prompted to convert the database, they must not under
any circumstances do this. Sometimes you can open the database with a 2000
version and when prompted specify open only, then from that point the users
will not be prompted again. This is not a guarantee.

There may be some other suggestions an MVP can make that I did not cover.

 

[John McInnis]

Barry,

One of my clients has a split Access db. The BE is in Acc97 while the FE's
are either Acc2k or Acc97. I hope to eventually move
all workstations to Acc2k and eventually Acc2k3. Meanwhile, users having
old Win98 PC's and Acc97 can still use BE database.
The only difficulty is that Acc2k users are complaining about slow response.
I'll have to move the BE database closer to the root on
the server (currently about 4 levels down) in improve response time. FE's
ran well in Acc97 and converted nicely to Acc2k BUT
were found to be a bit bigger. Acc2k is bigger, even after a compact, a
decompile and a final compact. Will have to investigate forms
to see if I can speed up the process.

JohnMc