Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    upgrade/separate app question (Access 97/2000/03)

    Currently have 97sr2 on all the stations I have access to (no pun intended).
    Client has 2000 db which requires work on.
    Options:
    1 - keep 97, install 2000 on separate workstation for client work = changing workstation to work on one clients data and kicking anyone else off this station when client needs work doing.
    2 - keep 97, install 2000 on same workstation - will this work? how easy to set up? can they be run on same workstation as separate apps?
    3 - keep 97, install latest access (2003 +sr's) on same workstation - will this work? how easy to set up? can they be run on same workstation as separate apps?
    4 - install 2003 on workstation, remembering to save as 2000/97 when need for different clients - how complicated would this be?

    Has anyone had experience of carrying any of the above out and are there foreseeable pitfalls other than the vba code and query strict adherence that appear in other threads.
    Thanks peeps?

    Alan Cheshire
    UK

    ps, if upgrading to Access 2000/2003, is it necessary to upgrade the remaining office components from 97sr2 (on windows XP)?

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

    Re: upgrade/separate app question (Access 97/2000/03)

    Do you actually have 2000 to install? Since it is no longer available retail, it can be hard to find. If you do not have it, you may be forced to use the 2003 option or at least to try and find an Access 2002 to install.

    You can, in fact run multiple versions of Access on the same machine. I've been doing it for years (and versions), so it is possible to keep 97 and install 2000 or 2003 on the same machine. Up through 2000, Office automatically installed to Program FilesMicrosoft OfficeOffice. After that, MS wised up and started installing to folders like Office 10 and Office 11, so you would only have to customize the installation if you did, in fact, install 2000. I recommend working in the version you need rather than backsaving, but that isn't always an option. If it is not, then at least keep 97 around to test the backsaved applications because it is incredibly easy to include features that don't work in an earlier version.

    The hardest part to remember is the file format, which sticks once set. However, it doesn't affect existing files, only new ones you create, so you can get confused quite easily. I recommend avoiding the 2002/2003 format for your data files unless you are creating an MDE, which requires the format of the version it's created in.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: upgrade/separate app question (Access 97/2000/03)

    WOW, thanks for the prompt reply Charlotte.
    I have an IT bod all prepped and ready to go out and find/install Access 2003(?) this weekend. (rather them than me in the christmas crowds).
    Yep, the scenario that is panning out is to install 2003, keep 97 for legacy clients, use 2003 to open/modify 2000db and save it in 2000 format.
    Tell me, what office version are you running it with. Do I need to update the rest of office?
    TIA
    Alan

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

    Re: upgrade/separate app question (Access 97/2000/03)

    I happen to be running Office XP and Access 97 on both machines, although I have Office 97, 2000 and XP developer versions all running on my laptop, including Access and the developer tools for each version. You don't need to update the rest of Office just to install Access 2003, but I think you will like 2003 better than Office 97 if you start using it. If you install only Access 2003 and not the rest of Office, you still need to do an Office install and just select the Access bits while telling the installer to keep Office/Access 97. Make sure you keep the help files for VBA and Office/Access 97 because you'll use them more than the 2003 version. In the 97 version, you can still find things! <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: upgrade/separate app question (Access 97/2000/03)

    Many thanks Charlotte.
    Got the full blown app this morning.

    Just had it installed (with a bit more confidence than had it been venturing into the unknown). Installation went fine with basic selections of "Do you wish to retain previous versions" etcetera.
    Can't believe how easy this was to install!
    Update pack 8 for Jet4.0 installed.

    Clients db looks fine for editing. First impressions are good.
    No doubt I'll have a few questions to post if it is too different from previous versions, but the help/search facility is looking good as well.

    Thanks
    Alan
    Cheshire, UK

Posting Permissions

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