MS Access Icon on Desktop help

[Jerry C]

I mail out two MDE databases. Test97 for Access 97 and
Test2000 for MS Access 2000 or MS Access XP.

The users have a MS Access icon on their desktops
pointing to their installed copy of Access.
How can I determine if their Icon points to Access 97 or
Access 2000 or Access XP?
Problem is:
If they open Test2000.mde with Access 97, they get a
Unrecogized database format error.
If they open Test97.mde with Access 2000, they get a
Can't Convert a MDE error.

I want to get with code their version of MS Access so I
can sent to their desktop a Icon pointing to the correct
Test97.MDE or Test2000.MDE database.

 

[Van T. Dinh]

Couldn't the users simply open Access (without any mdb or
mde), use the Menu Help/About Microsoft Access and find
out the Access version they have.

They can tell you the SR / SP as well so that you can
advise them whether they need to apply Service Releases /
Service Packs or not.

Low-tech method but it is reliable.

HTH
Van T. Dinh
MVP (Access)