Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    check version (Access 2000)

    Is there a way to check to see what version(s) of access a user has before opening the db? A way to search the hard drive for versions of access and then based on what version(s) they have it would open a specific application. Or at least a way for it to return to the user what version the have. I have users with mutiple versions of access installed and I don't know where to have there shortcut point to for the application. Thanks...

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: check version (Access 2000)

    This may be worth a look, never used it, but it might be an option.
    ================================================== =========
    ================================================== =========
    <A target="_blank" HREF="http://www.aadconsulting.com/facc.html">What is FreeAccess Access Control Center (FACC) v2.3 Beta?

    FACC manages all your Microsoft Access database projects from within an integrated project environment. FACC detects which supported versions of Access are installed on your PC, allowing you to organise projects by Access versions. Projects are managed centrally and .mdb's are opened by the appropriate Access version automatically. Each .mdb has it's own Notes record. The Shortcut Wizard creates desktop shortcuts for secured and unsecured databases. Compact, repair, and decompile files from within FACC. </A>

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: check version (Access 2000)

    If you have databases with multiple versions of Access installed, you are courting disaster. That is, unless you have split the databases and stored the front-end on their local hard drive. But even that is problematic - if somebody opens Access, and then decides to open a 97-version of Access in 2000 or 2002 and says yes to the convert question, you will almost certainly have a problem. It is possible to write a VB program that could check the version for you, and recommend a path for a shortcut, but the minute you get some smart user, you have the potential for trouble. You would be far better off to get rid of the extra versions and not have to worry about it. (If you have a commercial product that requires a full Access install and can't be converted, that might be a legitimate issue.) In the long run, 2000 or 2002 is a better choice and people can generally coexist in a shared front-end, though we don't recommend it.
    Wendell

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: check version (Access 2000)

    I'm not sure how you envision checking this. Is is quite possible to check from within Access to see if a database you are about to open was created with the same version of Jet as you are running, but I don't know if that is what you're looking for. The absolute safest way to handle this is by installing the runtime with your application and pointing to that executable in your shortcut. If you rely on the Access they have installed, you're asking for trouble, as Wendell has pointed out.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •