Different version of Access for frontend and backend.

[Squirrel]

I've developed an Access 2002 database which will be deployed with the
backend on
a server and frontend on the users' PCs. I've now been advised that new
employees will
be given laptops with Access 2003 installed and that the server software
will not be
updated. Also some of the users are using Access 2000 and some Access 2002.
My question is - will this work? There is a lack of IT support in this
department - they've
contracted with me to build a database - but I have no control over their
use of different
versions of Access. If it's going to be a complete mess it'd be great to
know that before
starting the install. I'd appreciate any advice anyone can offer as to what
I should expect.
Thank you.

Linda

[Steve Jorgensen]

Re: Different version of Access for frontend and backend.

On Mon, 2 Feb 2004 23:19:58 -0800, "Squirrel" <wiseowl@covad. net> wrote:
[color=blue]
>I've developed an Access 2002 database which will be deployed with the
>backend on
>a server and frontend on the users' PCs. I've now been advised that new
>employees will
>be given laptops with Access 2003 installed and that the server software
>will not be
>updated. Also some of the users are using Access 2000 and some Access 2002.
>My question is - will this work? There is a lack of IT support in this
>department - they've
>contracted with me to build a database - but I have no control over their
>use of different
>versions of Access. If it's going to be a complete mess it'd be great to
>know that before
>starting the install. I'd appreciate any advice anyone can offer as to what
>I should expect.
>Thank you.
>
>Linda
>
>[/color]


1. It doesn't matter what version of Access is on the server or even if any
version is installed at all. The server is just hosting a shared file, and
it's the client machines that care what format it's in.

2. Access 2003 will handle Access 2000 format files just fine. You can leave
the front-end in Access 2000 format, or upgrade it as you prefer. In any
case, the links to back-end tables in Access 2000 will work fine.

Now, the only issue you might have is with the front-end, not the back-end.
Sometimes, code written with one version will only work on another version
after you unselect and reselect some references, and decompile. It's possible
you'll have to maintain at least 3 distributions of the front-end, one for the
Access 200, one for 2002, and one for 2003. You should do all development
work in the oldest version in use, so you know it doesn't rely on any newer
features not available in older versions.

That said, if you can strongly encourage them to dump Access 2000, my
experience is that reliability of VBA code will be improved. I don't have any
experience with 2003 to compare, but 2002 has proven basically stable.

[Squirrel]

Re: Different version of Access for frontend and backend.

Steve,

Thank you for responding to my question. I had assumed that Access had to
be installed on the server and that therefore there could be some conflict
between different versions on the server vs the users' PCs. But if it isn't
even necessary for Access to be running on the server then I can see why
there will be no conflict. And thx for the recommendations on Access
2000/2002 and maintaining different versions on the users' PCs.

Linda

"Steve Jorgensen" <nospam@nospam. nospam> wrote in message
news:9blu10llvc ivm3jl9drhn310u rqg0m68ak@4ax.c om...[color=blue]
> On Mon, 2 Feb 2004 23:19:58 -0800, "Squirrel" <wiseowl@covad. net> wrote:
>[color=green]
> >I've developed an Access 2002 database which will be deployed with the
> >backend on
> >a server and frontend on the users' PCs. I've now been advised that new
> >employees will
> >be given laptops with Access 2003 installed and that the server software
> >will not be
> >updated. Also some of the users are using Access 2000 and some Access[/color][/color]
2002.[color=blue][color=green]
> >My question is - will this work? There is a lack of IT support in this
> >department - they've
> >contracted with me to build a database - but I have no control over their
> >use of different
> >versions of Access. If it's going to be a complete mess it'd be great to
> >know that before
> >starting the install. I'd appreciate any advice anyone can offer as to[/color][/color]
what[color=blue][color=green]
> >I should expect.
> >Thank you.
> >
> >Linda
> >
> >[/color]
>
>
> 1. It doesn't matter what version of Access is on the server or even if[/color]
any[color=blue]
> version is installed at all. The server is just hosting a shared file,[/color]
and[color=blue]
> it's the client machines that care what format it's in.
>
> 2. Access 2003 will handle Access 2000 format files just fine. You can[/color]
leave[color=blue]
> the front-end in Access 2000 format, or upgrade it as you prefer. In any
> case, the links to back-end tables in Access 2000 will work fine.
>
> Now, the only issue you might have is with the front-end, not the[/color]
back-end.[color=blue]
> Sometimes, code written with one version will only work on another version
> after you unselect and reselect some references, and decompile. It's[/color]
possible[color=blue]
> you'll have to maintain at least 3 distributions of the front-end, one for[/color]
the[color=blue]
> Access 200, one for 2002, and one for 2003. You should do all development
> work in the oldest version in use, so you know it doesn't rely on any[/color]
newer[color=blue]
> features not available in older versions.
>
> That said, if you can strongly encourage them to dump Access 2000, my
> experience is that reliability of VBA code will be improved. I don't have[/color]
any[color=blue]
> experience with 2003 to compare, but 2002 has proven basically stable.[/color]

[Tony Toews]

Re: Different version of Access for frontend and backend.

"Squirrel" <wiseowl@covad. net> wrote:
[color=blue]
>Thank you for responding to my question. I had assumed that Access had to
>be installed on the server and that therefore there could be some conflict
>between different versions on the server vs the users' PCs. But if it isn't
>even necessary for Access to be running on the server then I can see why
>there will be no conflict.[/color]

The most important thing though is to ensure everyone is at the same Jet 4.0 SP
version. Different versions could lead to corruptions.

What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the tips page at my website for more details including sample
code: Verify Appropriate Jet Service Pack is installed
www.granite.ab.ca\access\verifyjetsp.htm

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

[Squirrel]

Re: Different version of Access for frontend and backend.

Tony,

thx for your advice and the link to the code. I'll be sure everyone's
system is current before installing the database.

Linda


"Tony Toews" <ttoews@teluspl anet.net> wrote in message
news:gia020pps5 9dste1p8d6uesur f8rabm8mk@4ax.c om...[color=blue]
> "Squirrel" <wiseowl@covad. net> wrote:
>[color=green]
> >Thank you for responding to my question. I had assumed that Access had[/color][/color]
to[color=blue][color=green]
> >be installed on the server and that therefore there could be some[/color][/color]
conflict[color=blue][color=green]
> >between different versions on the server vs the users' PCs. But if it[/color][/color]
isn't[color=blue][color=green]
> >even necessary for Access to be running on the server then I can see why
> >there will be no conflict.[/color]
>
> The most important thing though is to ensure everyone is at the same Jet[/color]
4.0 SP[color=blue]
> version. Different versions could lead to corruptions.
>
> What I've done is use the various API calls available and am checking the[/color]
version[color=blue]
> number and date/time of a crucial dll, msjetxx.dll, to ensure it matches[/color]
what I have[color=blue]
> on my system. See the tips page at my website for more details including[/color]
sample[color=blue]
> code: Verify Appropriate Jet Service Pack is installed
> www.granite.ab.ca\access\verifyjetsp.htm
>
> 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[/color]