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

[JMCN]

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

 

[Douglas J. Steele]

That should work fine.

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

 

[Tony Toews]

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

 

[John Nurick]

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.