Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge problem (Office2000)

    I keep on getting the following message when I try to open a mail merged word document: The database has been placed in an state by the user

  2. #2
    BAM
    Guest

    Re: Mail merge problem (Office2000)

    Could be a temp (*.tmp) file causing the problem. Did Word hang or crash at some point with your mail merge document open?

    Exit Word and Outlook (if using Word as the default email editor) and search for all *.tmp and ~$*.do? files and delete those you find.

    Although I may not be necessary, exit Access and search for all *.lbd files and delete those you find as well. Also, open your database and go to Tools/Database Utilities/Compact Database.

    If you can't open the database then did you try to open it directly in Word and save it at some point?
    ~~~~~~~~~~~~~~
    Cheers! <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  3. #3
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge problem (Office2000)

    Thank you, RAM.
    My mail merge document never froze and I don't know what is causing it.
    I'll try compacting it.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    BAM
    Guest

    Re: Mail merge problem (Office2000)

    You should still do a search for all temp files as I suggested even though Word didn't hang or crash.

    What you describe suggests a leftover temp file that contains a lock on the database. Also, you might want to try rebooting in case the Winword task is not being released.

    Also, how are you opening the mail merge document programmatically from Access?
    ~~~~~~~~~~~~
    Cheers! <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>

  5. #5
    4 Star Lounger
    Join Date
    Aug 2001
    Location
    London, UK
    Posts
    516
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge problem (Office2000)

    I'll try to delete all the temp files, but I'm working in a network enviroment, would it affect anything if I delete these files? (I don't want to cause any problem to the network or the company Im working for)
    I'm running the mail merge documents from access using a module.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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