By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,689 Members | 1,787 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,689 IT Pros & Developers. It's quick & easy.

Compatibility Access 2000 and 97

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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


Nov 12 '05 #2

P: n/a

"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
Nov 12 '05 #3

P: n/a
> 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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.