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
412 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
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 …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

749 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