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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

695 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