Multiple Versions

[doodle]

greetings. access 97/2k. about 10% of my users are running 2k and the
rest 97. approx. 60 users currently, access FE and sql 2005 BE.

the issue is that right now i have to support 97 and 2k. i run both
and test on both on my machine. now IT is upgrading from 97 to 2007!
yikes! but, even though they say otherwise, this will not be a company
wide move for sometime. so i am going to have users on 97, 2k and
2007.

what is the easiest way to do this? should i move the FE to VB? This
is a huge app and it will take months to rewrite everything, but i am
going to have to make changes for 2007 as well.

i welcome any advice that would keep me from an ulcer.

-doodle

 

[Albert D. Kallal]

in past times, I had clients upgrading (over time) from access97 to access
2003.


the solution was to lave the back end in access97, but roll out a new front
end in a2003.

You should be able to do the same in this case also....

It was interesting, but they were upgrading other products (like maximizer)
etc at the same time, and they were absolute shocked, since they always
heard how much of a pain it is to run ms-access, and yet we provide the
customer the smoothest upgrade compared to all of the other venders.

So, we had a mix of access97, and access 2003 users until all desktops were
finished being upgraded. However, there was no interruption of use the
application at all....

 

['69 Camaro]

Hi.

what is the easiest way to do this?

Make a copy of the Access 2000 front end and modify that for the Access 2007
users. You don't need to convert it from MDB to ACCDB format unless you
need to use the features that are only available in the ACCDB format.
However, for your sanity, it's probably better to avoid the new Access 2007
features until you're only supporting one version of an Access front end.
Expect lots of support calls from the Access 2007 migrators, because the
Access 2007 interface is so different from earlier versions that the users
are accustomed to.

Good luck. Supporting three different front ends isn't something I'd wish
on anyone, but it's very do-able if the application is well-designed.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[SJ]

You might want to get them all up to using 2k by issueing them with an
Access2k runtime version.

An upgrade to Access2007 is probably possible depending on how you have
coded your app.

You can only really tell by running the thing under 2007.

It sounds like you have time to sort things out. It might not be a hassle
at all.