Results 1 to 4 of 4

Thread: Mail Merge (XP)

  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Ocean, New Jersey, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (XP)

    Just moved an application to the user's server. Had intended to split the database and keep a copy of the FE and the "merged" Word documents on each of several user laptops. The BE would remain on the server. The user prefers that the entire application remain on the server. So the Word documents and the Access application/DB are resident in the same folder on the server, and I re-sourced the Word documents to the server. However, the first laptop complained that the source was missing. Does it look first at its own "My Data Sources" folder? I removed all existing data sources in that folder. It looked like it was working, but then the application became corrupted and I had to reload from backup. What happened? Does each laptop need to be "pointed" to the server data source? How can I do that safely?
    Thanks.

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

    Re: Mail Merge (XP)

    Your user may have done themselves in by wanting everything on the server. That means you can't make any design changes in your Access application until they are all kicked out - since XP requires that you have exclusive access to make design changes to forms, reports and code. Be that as it may, you should be able to move the Word merge docs to the server and make it work. One issue may be the drive letter that was used to point to the Access database. All users will need to have the same exact mapping to the folder, or you will continue to have problems.

    A couple of questions:
    What kind of data source are you using - a table or a query?
    How is the merge initiated - from Word, or from Access using Automation?
    Well, three - you said the "application became corrupted" - are you referring to the Access database?
    Wendell

  3. #3
    New Lounger
    Join Date
    Jan 2003
    Location
    Ocean, New Jersey, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (XP)

    Thanks for the quick response.
    1)Data sources are all tables
    2)Merge is initiated from access
    3)The DB became corrupted; the repair opportunity offered by the error message failed.

    When you refer to the drive letter, do you mean that (for example), if the data source on the server refers to the D drive, that each laptop will need corresponding data sources pointing to the same D drive on the server? Any details you can provide are GREATLY appreciated.

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

    Re: Mail Merge (XP)

    <hr>When you refer to the drive letter, do you mean that (for example), if the data source on the server refers to the D drive, that each laptop will need corresponding data sources pointing to the same D drive on the server? Any details you can provide are GREATLY appreciated. <hr>
    In general, yes though we use a trick where we don't store the data source in the document and then set it using automation. There are some recent posts (last few days) on doing that, and several links to detailed information.
    <hr>The DB became corrupted; the repair opportunity offered by the error message failed.<hr>
    Another of the problems of trying to run a front-end on the server - somebody crashes and the database is corrupted and everyone has to get out so a compact and repair can be run. With the front-end on the workstation, all you have to do is replace the one on the workstation that crashed. And you get better performance opening forms and reports.
    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
  •