Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Ft Collins, CO
    Posts
    22

    Question Unanswered: Mail Merge Help...

    Hello,

    Here's a little background:

    All of our users have the following Office components installed on their systems:
    Word 2000
    Excel 2000
    Outlook 2000
    Access 97

    Now, we've starting moving all the machines up to Access 2000, but we have to keep the 97 installation intact "just in case." The problem we've run into, however, is that when we try to use the Mail Merge function in Word and try to use an Access database as the data source, it wants to open it as a 97 database. Does anyone know how to change that so it's looking for a 2000 database? Is that a registry change?

    Thanks,
    Bill

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    You are pushing your luck by having both on one machine. Both Access 97 and 2K are like sworn enemies to each other...!!!! You can try to check the options and setting for MS word. or try checking MSDN.

  3. #3
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    set the associations for mdb to the access xp and also make sure that the source for the merge is not pointing to a 97 backend (data)

  4. #4
    Join Date
    Jan 2004
    Location
    Ft Collins, CO
    Posts
    22
    Tried that. I went through my file type associations and changed the path for every action of every file of type "Microsoft Access *" and it still didn't work. The database I'm using to test does not have any linked tables, but I did run through the good database and made sure that all the linked databases are in fact 2000 dbs. Sigh...

  5. #5
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    right hand click an mdb file select openwith - point to the msaccess.exe that represents acc2000, also make sure that macro, code, etc is not looking for an acccess 97 (v8 i believe object library or the office 8.0) I fso you may need to reference the office 9.0 object library

Posting Permissions

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