Results 1 to 7 of 7

Thread: MS Access Version

  1. May 6th, 2002, 01:54 PM #1
    AlterEgo
    AlterEgo is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2002
    Location
    Rome, Italy
    Posts
    150

    MS Access Version

    How to tell what version of Access is running on PC?
    Catholics Do It With Beads
    Reply With Quote Reply With Quote
  2. May 6th, 2002, 02:00 PM #2
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    In Access go to HELP>ABOUT and it will tell you the version.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  3. May 6th, 2002, 02:04 PM #3
    AlterEgo
    AlterEgo is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2002
    Location
    Rome, Italy
    Posts
    150
    Thank you Memnoch1207, but I need my VB program to tell me what version of Access is on PC.
    Catholics Do It With Beads
    Reply With Quote Reply With Quote
  4. May 6th, 2002, 02:39 PM #4
    bobp
    bobp is offline
    New Member
    Join Date
    Apr 2002
    Posts
    11
    I think this is more like what you are looking for:

    VB Code:
    1. 'Set A Reference To MS Access Object Library

    2. 'Set A Reference to MS DAO 3.6 or later

    3.  
    4.  
    5. Private Sub Command1_Click()

    6. Dim Axs As Access.Application

    7. Set Axs = New Access.Application

    8. Axs.OpenCurrentDatabase ("c:\codelib\codelibrary.mdb"), False

    9. MsgBox Axs.CurrentDb.Version

    10. End Sub

    11.  
    12. 'Access 2.0 database will return 2.0

    13. 'Access 95 database will retrun 3.0

    14. 'Access 97 database will return 3.0

    15. 'Access 2000 database will return 4.0
    Reply With Quote Reply With Quote
  6. May 6th, 2002, 03:43 PM #5
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    XP will also return 4.0
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  7. May 6th, 2002, 06:43 PM #6
    AlterEgo
    AlterEgo is offline

    Thread Starter
    Addicted Member
    Join Date
    May 2002
    Location
    Rome, Italy
    Posts
    150
    Thank you very much Mr. bobp...this is most useful.

    Mr. Memnoch1207 - I do not understand...XP is OS, correct, Access is database so I do not understand XP will also return 4.0
    Catholics Do It With Beads
    Reply With Quote Reply With Quote
  8. May 7th, 2002, 02:11 AM #7
    WiseGuy
    WiseGuy is offline
    Lively Member WiseGuy's Avatar
    Join Date
    Apr 2002
    Location
    Zierikzee, The Netherlands
    Posts
    98
    I think he means Acces XP (or acces 2002)


    WiseGuy
    I stuck my head out of the window and got arrested for mooning!

    This Post is sponsored by my PC: PIII900, 512MBDimm/133, Seagate 40GB/7200 ATA100, LiteOn 12x DVD, Lite-On 32x12x40 CDrw, Elsa Geforce2 Ultra 64MB incl tv-out, SoundBlaster Live 1024, Ilyama A702HT Vision Master Pro410 17".
    O/S: Windows XP Professional (dutch)
    Internet: Cable (1Mbit connection)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width