Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2000 or 2003 (2003)

    I know this has been covered before, but I'm stuffed if I can find any reference to it. However, I'm developing a multi-user DB for work & I need to optimise it for performance.

    I've already got many things covered, but I wonder if there are any performance issues on the different versions available to us (2000 & 2003).

    TIA Paul

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: 2000 or 2003 (2003)

    Access 2003 can work with databases in Access 2000 format and in Access 2002/2003 format; no conversion is needed.
    Access 2000 cannot read Access 2002/2003 format databases at all, they will have to be converted to Access 2000 format on a machine with Access 2002 or 2003 installed.
    The Access 2002/2003 format produces larger database files, and seems to be more prone to expand while in use than the Access 2000 format.

    So whether you use Access 2000 or 2003, I would recommend creating the database in Access 2000 format, or rather a backend and frontend in Access 2000 format. If it is to be used by both Access 2000 and Access 2003 users, create separate front ends for the two versions - both will be in Access 2000 format, but have different references set.

    Make sure that everyone has the latest service packs for Access/Office and for Jet 4.0 installed.

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 or 2003 (2003)

    Many thanks, Hans. What you said does confirm what I read somewhere. Thankfully all users will have exactly the same version & SP (v1) .So with that, I'll be developing it in 2000.

    About the latest service packs, we're constrained by our European HQ on what we can have, which is currently SP1. Also how can I tell which Jet version we're using?

    Ta muchly. Paul

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 or 2003 (2003)

    Paul

    Try this:

    Implementation by ATTAC Consulting Group, Ann Arbor, MI USA. Freely Distributed

    John


    Go to I window

    ?atGetjetver
    4.0.8618.0


    <pre>Function atGetjetver() As String
    '*******************************************
    'Purpose: Returns Version information on Jet DB Engine
    ' Based on the Version of Access Used
    '*******************************************
    Dim Buffer As fBuffer
    Dim VInfo As VS_FIXEDFILEINFO
    Dim stBuf() As Byte
    Dim lSize As Long
    Dim stUnused As Long
    Dim ErrCode As Long
    Dim VerNum As Variant
    Dim lVerPointer As Long
    Dim lVerbufferLen As Long
    Dim Jet$

    Jet = "MSJet40.dll"

    lSize = ac_GetFileVersionInfoSize(Jet, stUnused)
    ReDim stBuf(lSize)
    ErrCode = ac_GetFileVersionInfo(Jet, 0&, lSize, stBuf(0))

    ErrCode = ac_VerQueryValue(stBuf(0), "", lVerPointer, lVerbufferLen)

    If ErrCode <> 0 Then
    ac_MoveMemory VInfo, lVerPointer, Len(VInfo)

    VerNum = Format$(VInfo.dwFileVersionMSh) & "." & _
    Format$(VInfo.dwFileVersionMSl) & "." & _
    Format$(VInfo.dwFileVersionLSh) & "." & _
    Format$(VInfo.dwFileVersionLSl)
    End If
    atGetjetver = VerNum
    End Function
    </pre>


  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 or 2003 (2003)

    You will need the attached from ATTAC Consulting Group, Ann Arbor, MI USA. Freely Distributed

    Implementation by ATTAC Consulting Group, Ann Arbor, MI USA. Freely Distributed

    HTH, John

  6. #6
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2000 or 2003 (2003)

    Thanks John. Kinda like that.

    Paul

Posting Permissions

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