?
Solved

Why do I receive the message from Publisher 2003: this operation cannot be completed because of dialog or database engine failures.

Posted on 2007-11-16
2
Medium Priority
?
449 Views
Last Modified: 2013-12-02
I'm doing a mail-merge in Publisher 2003 to place address information on the reverse side of a postcard mailing. The names and addresses are located in an Excel 2003 spreadsheet. This is a update to a previously successful mailing. But now when I launch Publisher and try to open my postcard, it tells me it can't find the data source. When I choose to locate the data source myself and wend my way to it, I get the message "this operation cannot be completed because of dialog or database engine failures." and Publisher can't open the postcard document. Does anyone know how to solve this problem or to work around it? Thanks. -- Tim Dempsey  -- P.S. I have already checked that my MDAC components are up to date.
0
Comment
Question by:Clocktower2
2 Comments
 
LVL 4

Expert Comment

by:Dozer42
ID: 20303035
This problem may occur if the Microsoft Data Access Component (MDAC) files on your computer are not the latest version.

Update the Microsoft Data Access Component (MDAC) files

Full details here:

http://support.microsoft.com/kb/322215
0
 
LVL 4

Accepted Solution

by:
dgage123 earned 2000 total points
ID: 20553345
Did the merge in question used to work at one time and then got corrupted ... or has it never worked ... or it worked once then wouldn't do it again ... or it hasn't worked since you upgraded?

Also, did you create the database originally, or is it a database that had been around for years, or is it a database from another program that was inserted or copied into Excel?

Here is something you may want to try:
Open your Excel sheet (the database), copy the table (just the cells, don't copy the whole sheet), paste it into a brand new spreadsheet, and save it (assuming that the entire database is on one spreadsheet).
Recreate your Publisher merge document (the postcards) and associate it with this new Excel file database. Then try the merge again.

Or, have you resolved it another way already?


0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question