access 97 backend with 2000, 2002, and 2003 front ends

Is this possible to have the 97 users with 97 front end, 2000 users
with 2000 front end, 2002 users with 2002 front end, and 2003 users
with 2003 front end all linked up to an access 97 backend?

We are currently planning on upgrading workstations with either 2000,
2002, 2003. the criteria for the specific version will depend on the
IT department. I would like to know if we have several different
office versions will it work to have access 97 as a back end??

thanks in advance
jung

re: access 97 backend with 2000, 2002, and 2003 front ends

That should work fine.

Same rules as usual: make sure everyone has their own copy of the front end,
preferably on their hard drive.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"JMCN" <picarama@yahoo.fr> wrote in message
news:2772ee20.0405181252.6fa8b4e@posting.google.co m...[color=blue]
> Is this possible to have the 97 users with 97 front end, 2000 users
> with 2000 front end, 2002 users with 2002 front end, and 2003 users
> with 2003 front end all linked up to an access 97 backend?
>
> We are currently planning on upgrading workstations with either 2000,
> 2002, 2003. the criteria for the specific version will depend on the
> IT department. I would like to know if we have several different
> office versions will it work to have access 97 as a back end??
>
> thanks in advance
> jung[/color]

re: access 97 backend with 2000, 2002, and 2003 front ends

picarama@yahoo.fr (JMCN) wrote:
[color=blue]
>Is this possible to have the 97 users with 97 front end, 2000 users
>with 2000 front end, 2002 users with 2002 front end, and 2003 users
>with 2003 front end all linked up to an access 97 backend?[/color]

From personal experience A2000 FE works just fine with A97 BEs. Presumably so would
A2002 and A2003.

Also make sure they are up to date on Jet versions. And that all users have the same
Jet version.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

re: access 97 backend with 2000, 2002, and 2003 front ends

JMCN wrote:[color=blue]
> Is this possible to have the 97 users with 97 front end, 2000 users
> with 2000 front end, 2002 users with 2002 front end, and 2003 users
> with 2003 front end all linked up to an access 97 backend?
>
> We are currently planning on upgrading workstations with either 2000,
> 2002, 2003. the criteria for the specific version will depend on the
> IT department. I would like to know if we have several different
> office versions will it work to have access 97 as a back end??
>
> thanks in advance
> jung[/color]

It will work ok, but I have noticed a major performance loss when
linking to an A97 backend on a network. Converting the backend to A2000
fixed the issue.
--
regards,

Bradley

re: access 97 backend with 2000, 2002, and 2003 front ends

On Tue, 18 May 2004 22:00:10 GMT, Tony Toews <ttoews@telusplanet.net>
wrote:
[color=blue]
>From personal experience A2000 FE works just fine with A97 BEs. Presumably so would
>A2002 and A2003.[/color]

I'm trying A2003 against an A97 back end (secured, 60+tables) with no
problems to date.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

re: access 97 backend with 2000, 2002, and 2003 front ends

> It will work ok, but I have noticed a major performance loss when[color=blue]
> linking to an A97 backend on a network. Converting the backend to A2000[/color]

You do still have to set SubDataSheet to [none]. This property
does not display in Access 97, and Access 2000+ won't let you
change it on an A97 format database, so you have to do this with
(VBA) code.

(david)

"Bradley" <bradley@REMOVETHIScomcen.com.au> wrote in message
news:rlzqc.46782$TT.41834@news-server.bigpond.net.au...[color=blue]
> JMCN wrote:[color=green]
> > Is this possible to have the 97 users with 97 front end, 2000 users
> > with 2000 front end, 2002 users with 2002 front end, and 2003 users
> > with 2003 front end all linked up to an access 97 backend?
> >
> > We are currently planning on upgrading workstations with either 2000,
> > 2002, 2003. the criteria for the specific version will depend on the
> > IT department. I would like to know if we have several different
> > office versions will it work to have access 97 as a back end??
> >
> > thanks in advance
> > jung[/color]
>
> It will work ok, but I have noticed a major performance loss when
> linking to an A97 backend on a network. Converting the backend to A2000
> fixed the issue.
> --
> regards,
>
> Bradley
>
>[/color]

re: access 97 backend with 2000, 2002, and 2003 front ends

Try to avoid mixing Windows versions, different users with a mixture
of A97, XP & Win2000 can corrupt a database in a short time.

re: access 97 backend with 2000, 2002, and 2003 front ends

envirocomp@ukonline.co.uk (Bill Elgie) wrote:
[color=blue]
>Try to avoid mixing Windows versions, different users with a mixture
>of A97, XP & Win2000 can corrupt a database in a short time.[/color]

I'm not going to agree with you here. A client is happily running A97 on NT 4.0
systems and A2000 on Win 2000 Terminal Servers with very, very few problems.

Now with a mixture of Win 9x (95, 98 and ME) and NT (NT 4.0, 2000 and XP) then yes
that could be a problem. But the OpLocks fix seems to take care of that one.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm