Compatibility Access 2000 and 97

[Pat]

We have a database with Access 97 as the front-end and SQL7 as the
back end. It is on a network server and accessed by joining a MS
Access Workgroup.

We are trying to add a new user and have purchased Access 2000 for
their computer. We are now being told that they will not be able to
view, or make entries, queries because Access 2000 is not compatible
with Access 97 and the workgroup will not allow two versions of Access
to be utilized. Before we go and install this (Access 2000) at this
remote location (its a 2 nhour drive just for us to get there---don't
want to waste our time) is it true that Access 2000 can not read
Access 97 dbs and is the problem associated with the MS workgroups?
Is there a workaround----or do we have to get another license for
Access 97? Thanks - Pat

[Arno R]

Pat,
A2000 will not work with an A 97 mdb.
A 2000 can 'read' everything (importing A 97 objects to A2k is no problem) but
to really work with the mdb you will have to convert your A97 mdb to A 2000.
If there is no security involved then you can just run the conversion-wizard and go on from there.

But: Every (A 97) update to the application will need to be converted.
I am not 100% sure but I think you are allowed to install and use Access 97 with a A 2000 licence.
(As long as you don't use both versions that is.)

--
Hope this helps
Arno R


"Pat" <pp*****@bjc.org> schreef in bericht news:6e**************************@posting.google.c om...

We have a database with Access 97 as the front-end and SQL7 as the
back end. It is on a network server and accessed by joining a MS
Access Workgroup.

We are trying to add a new user and have purchased Access 2000 for
their computer. We are now being told that they will not be able to
view, or make entries, queries because Access 2000 is not compatible
with Access 97 and the workgroup will not allow two versions of Access
to be utilized. Before we go and install this (Access 2000) at this
remote location (its a 2 nhour drive just for us to get there---don't
want to waste our time) is it true that Access 2000 can not read
Access 97 dbs and is the problem associated with the MS workgroups?
Is there a workaround----or do we have to get another license for
Access 97? Thanks - Pat

[Rick Brandt]

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...

Pat,
A2000 will not work with an A 97 mdb.
A 2000 can 'read' everything (importing A 97 objects to A2k is no problem) but to really work with the mdb you will have to convert your A97 mdb to A 2000. If there is no security involved then you can just run the

conversion-wizard and go on from there.

This would only apply to *design changes*. One can certainly open an
Access 97 file in Access 2K without converting it and enter/edit DATA.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Arno R]

> This would only apply to *design changes*. One can certainly open an

Access 97 file in Access 2K without converting it and enter/edit DATA.

You are absolutely right on this. I was just too quick in answering.
I was 'thinking' of an A97 mde (I always distribute mde's nowadays) while I wrote:
"A2000 will not work with an A97 mdb".
Should be: "A2000 will not work with an A97 mde".

But:
When you just open a A97 mdb in A2k you will experience an enormous bloat.
The file will increase until nearly twice the size by just opening the mdb.
I just don't trust it so I never tested this for *real*.

I think the OP will be better off (consider maintanance) with the same version for every user.

--
Arno R