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
409 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

839 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