Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge and Access (Office 2000 and Access 97)

    Is it possible to have both Access 97 and Access 2000 installed on the one computer and have Word use Access 97 for mail merges?

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

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

    Re: Mail merge and Access (Office 2000 and Access 97)

    It's possible to have both versions of Access on the same machine, although there are some potential conflicts, and you're skating around one of them. Word 2000 doesn't know which version of Access it should be using. Perhaps if you explain more specifically what you're trying to do, someone can help you. If there some reason to use Access 97 instead of just converting the database to 2000?
    Charlotte

  4. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge and Access (Office 2000 and Access 97)

    I cannot convert the database to 2000 as other users only have Access 97. The mail merge is just a form letter from a staff database. Is there some way to tell Word 2000 which version of Access to use?

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

    Re: Mail merge and Access (Office 2000 and Access 97)

    Have you tried it on a machine with Access 97 only? Office 2000 can open Office 97 documents, so I would be surprised if it didn't work on those machines. It's only machines with two versions where you might have problems because Access 2000 will open a 97 database, but it wants to convert it.
    Charlotte

  6. #5
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge and Access (Office 2000 and Access 97)

    Yes. Iset that up on Friday and it works fine. However, the person concerned wants to start using Access 2000 as well. Maybe he will have to wait until everyone is converted to Office 2000 if you cannot tell Word which version of Access to open.

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

    Re: Mail merge and Access (Office 2000 and Access 97)

    We solve this problem by splitting the database and creating an Access 2000 and an Access 97 front-end. That way those that want to run Office 2000 can do the merges using Access 2000 and Word 2000, while those still running 97 use the 97 front-end. You don't want to run that way for a long time, as Access 2000 takes a rather sizeable performance hit using and Access 97 back-end, but it will work while you do an upgrade and isn't too painful. If you need further details, post back.
    Wendell

Posting Permissions

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