Determine Access Version

[Jeff G]

All -

I'm in the process of converting my users to Access '07. In the meantime, I
have 2 versions of the database - one for '03 and one for '07. I have an
event that goes out and updates the client if there is a newer version.

What I'd like to be able to do is to check if '07 is installed and if so,
launch the update to install the '07 version of the client database. If
not, then install the '03 version.

I know how to fire the event using an if..then, but where I'm lost is how to
determine if '07 is installed.

Any help would be much appreciated.

Jeff

 

[John Mishefske]

I'm in the process of converting my users to Access '07. In the meantime, I
have 2 versions of the database - one for '03 and one for '07. I have an
event that goes out and updates the client if there is a newer version.

What I'd like to be able to do is to check if '07 is installed and if so,
launch the update to install the '07 version of the client database. If
not, then install the '03 version.

I know how to fire the event using an if..then, but where I'm lost is how to
determine if '07 is installed.

? currentproject.Application.Version
12.0


--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com

 

[Jeff G]

Yes...Access '07 v12 and Access '03 v11.

? currentproject.Application.Version
12.0


--
John Mishefske, Microsoft MVP 2007 - 2009
UtterAccess Editor
Tigeronomy Software
web: http://www.tigeronomy.com
email: sales ~at~ tigeronomy.com

 

[Jeff G]

But, that would only work for the current database.

I'd like to have the database that is running in Access '03 to check and see
if Access '07 is installed and if so, download the '07 version of the
database. If not, download the '03 version.

 

[Tony Toews [MVP]]

But, that would only work for the current database.

I'd like to have the database that is running in Access '03 to check and see
if Access '07 is installed and if so, download the '07 version of the
database. If not, download the '03 version.

The only reliable way is to use the registry. Poke about looking for msaccess.exe
and decide which one suits your requirements. It'll be under a registry with 12.0 in
the registry path.

However why bother? Why not let the A2007 users run the A2003 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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jeff G]

The reason that I'd like to have them on A2007 is that with the different
functionality in A2007, I've redeveloped the application. But, since not
all are on A2007 I have to provide the application to A2003 users.

 

[david]

This is for clients that have both '03 and '07 installed? You have
another problem coming: when they download the new version,
they will try to open it the same way they opened the old version,
and it will fail.

(david)

 

[Tony Toews [MVP]]

The reason that I'd like to have them on A2007 is that with the different
functionality in A2007, I've redeveloped the application. But, since not
all are on A2007 I have to provide the application to A2003 users.

Why not use the free Access 2007 runtime to give all your users access
to the new version?

Microsoft Office Access 2007 Developer Edition FAQ
http://www.granite.ab.ca/access/developeredition2007faq.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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jeff G]

The Client has a shortcut that references what version.

 

[david]

So you need to know the location of msAccess.exe to
create the shortcut.

If you install a new version you need to know the
location of the msaccess.exe you are going to use in
the shortcut.

How do you create the shortcut? Are you assuming
a location for msAccess.exe? Does the user need
to create the shortcut? Or do you have a program that
creates the shortcut?

If you have a program to create the shortcut, you can
just add extra code to get the version number from the
executable. Have you got that?

(david)