Results 1 to 14 of 14
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2000 (2000)

    At work I have Office 2000 Pro, which includes Access. We just got Office 2002 Standard, which does not include Access. If I install the new version of Office will I still be able to run Access 2000? What would I have to do to enable this to work?

    Thanks,
    Randy

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

    Re: Access 2000 (2000)

    You may still be able to get it to load, but I wouldn't trust it at all - Office has lots of shared DLLs, and the VBA version with Office 2002 is a fair bit different than 2000. If you can't hold out for Office XP Pro (with Access), then I would either install 2002 in a separate directory and keep Office 2K, or I wouldn't install it at all. There aren't many compelling reasons for upgrade unless you fall into certain niche categories - that's true of Access as well. If you have further concerns, please post back.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access 2000 (2000)

    If you do install the new version, install it in a separate directory. Do NOT allow the install program to do anything with the old version. It used to ask you sweetly if you wanted to "clean-up" the old version; which meant deleting it! There are some articles in the MSKB about installing multiple versions of Access on the same PC.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access 2000 (2000)

    Actually, with Office 10/XP, Microsoft took pains to make Office install to its own directory by default. So when you install XP, You get an Office 10 folder without even trying. However, in the install, the wizard lists the programs it will remove and you need to change that or it will remove the earlier versions. Since Standard is a downgrade, you should be able to remove Access from the list of programs to be removed and keep it on that machine.
    Charlotte

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access 2000 (2000)

    Thanks, I haven't upgraded to XP yet, so I wasn't aware they made it easier to have multiple copies of Office. I still remember an install when I unfortunately said "Yes" to the offer to "clean-up" the prior version, not realizing what that meant!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access 2000 (2000)

    The one thing you still have to watch out for is the system.mdw, which will get overwritten. XP and 2000 can use the earlier version but earlier versions can't use the later system.mdw, so it pays to be careful and rename the existing system.mdw before installing a new version.
    Charlotte

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access 2000 (2000)

    Where does Access write that system.mdw file by default? I'm looking at my laptop which has both A97 and A2000 on it, and there is A97 system.mdw is in C:WindowsSystem, while the A2000 system.mdw is in the directory that contains Office2000. I don't remember if I did anything special when I installed Office 2000 (other than to specify the directory).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access 2000 (2000)

    I believe the default location is Windows, depending on the version of Windows and Office. However, the 2000 packaging wizard puts it in Program FilesCommon FilesSystem. And if you want to use it in a shortcut without fully referencing the path, it needs to be somewhere like WindowsSystem32. It's been so many years since I had a single installation of Access on my machine that I'm not sure any longer where it goes. I do know that I don't have a system.mdw in any of the Office folders, so I suspect that's something you did after the fact.
    Charlotte

  9. #9
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 (2000)

    In addition to what else has been said, you need to watch out for Office XP overwriting the VBE6.dll with a newer version (MSKB 304548 talks about this or this Lounge search on vbe6.dll ). This can cause problems with Access 2000. If you are up to date with the office 2K srevice releases (SR3 installed) then it won't be a problem.

    If you haven't installed SP3, you should to prevent these problems.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

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

    Re: Access 2000 (2000)

    You can't prevent the dll being overwritten, so you have to patch the Access 2000 executable to handle the updated dll. I would imagine that MS has pulled the previous hotpatch off its website since Office 2000 SR3 includes it and is now referenced in that MSKB article. It should be noted, however, that the problem only exists between Office XP and Office 2000. Since 97 was based on VB5, it used a different dll for the VBE and isn't affected by the same problem.
    Charlotte

  11. #11
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 (2000)

    Quite right Charlotte. That's what I was trying to say, but failed miserably. I guess I wasn't very clear.

    Let's chalk it up to a house full of stomach flu <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

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

    Re: Access 2000 (2000)

    In 2002 under Windows ME, it puts the security file in WINDOWSApplication DataAccess - but what's really a pain is if you have a secured database and you switch back and forth between versions, a couple of versions relocate to the default system.mdb if you previously started a different version. I got sick of that and put each version on a different PC finally.
    Wendell

  13. #13
    New Lounger
    Join Date
    Feb 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 (2000)

    Thank you all for the quick replies. I think my life will be simpler if I just stay with Office 2000. As was said, there aren't any compelling reasons to upgrade and I sure don't want to deal with any possible loss of our database.

    Thanks again.

  14. #14
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Access 2K - Workgroup File Location (A2K)

    Supposedly, the default SYSTEM.MDW workgroup file in A97 is installed in the Windows System folder. According to ACC97: Understanding the Role of Workgroup Information Files in Access Security: "When you install Microsoft Access and open a database for the first time, a new file named System.mdw is created in the WindowsSystem folder. This file is the default workgroup information file. " The A2K version of this article states: "When you install Microsoft Access for the first time, a new file is created in the Program FilesCommon FilesSystem folder. ...The default workgroup information file is named System.mdw." (MSKB Art 305541). In AXP/A2002 it depends on which version of Windows is installed. According to MSKB Art 305542:

    "By default, on computers that are running Microsoft Windows 2000, the System.mdw file is created in the user profile in the following path.

    "NOTE: The Application Data folder is a hidden folder.
    Cocuments and Settings<user name>Application DataMicrosoftAccessSystem.MDW

    "On computers that are running Microsoft Windows 98, the default System.MDW file is created in the following path:
    C:WindowsApplication DataMicrosoftAccessSystem.MDW "

    If you have A97 and A2K installed on same computer, ACC2000: Workgroup Information File Is Reset to Default System.mdw After Self-Registration states in part:
    <hr> When you run Access 97, Access 97 reregisters itself and makes itself the current version of Access on the computer; this means that at this point, if you click on an Access database, Access 97 tries to open the database. Likewise, when you run Access 2000 after running Access 97, Access 2000 reregisters itself, and makes itself the current version. When Access 2000 reregisters, Access 2000 also rewrites the System.mdw location to the Windows registry. The location written to the registry is always the location determined when Access was first installed on the computer. If Access 97 does not find the System.mdw file location there, Access 97 displays a message that the System.mdw file could not be found. If Access 2000 does not find the System.mdw file location there, Access 2000 starts the repair process to create a default System.mdw file with no security defined.

    The following is an example of the registry keys that are rewritten when Access self-registers.

    Access 97:
    HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice8.0Access Jet3.5Engines

    Name = SystemDB
    Data = <path of WindowsSystem folder>System.mdw

    Access 2000:
    HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice9.0Access Jet4.0Engines

    Name = SystemDB
    Data = <path you defined during Setup>System.mdw <hr>

    I hope this clarifies (??) the issue....

Posting Permissions

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