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
407 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 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Viewers will learn the different options available in the Backstage view in Excel 2013.
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…

832 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