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

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

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


P: n/a
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" <pi******@yahoo.fr> wrote in message
news:27*************************@posting.google.co m...
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

Nov 12 '05 #2

P: n/a
pi******@yahoo.fr (JMCN) wrote:
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?


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

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


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

P: n/a
On Tue, 18 May 2004 22:00:10 GMT, Tony Toews <tt****@telusplanet.net>
wrote:
From personal experience A2000 FE works just fine with A97 BEs. Presumably so would
A2002 and A2003.


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.
Nov 12 '05 #5

P: n/a
> 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
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" <br*****@REMOVETHIScomcen.com.au> wrote in message
news:rl******************@news-server.bigpond.net.au... JMCN wrote:
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


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

Nov 12 '05 #6

P: n/a
Try to avoid mixing Windows versions, different users with a mixture
of A97, XP & Win2000 can corrupt a database in a short time.
Nov 12 '05 #7

P: n/a
en********@ukonline.co.uk (Bill Elgie) wrote:
Try to avoid mixing Windows versions, different users with a mixture
of A97, XP & Win2000 can corrupt a database in a short time.


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

This discussion thread is closed

Replies have been disabled for this discussion.