Solved

While in Access Runtime OutputTo Fails

Posted on 2008-10-29
15
923 Views
Last Modified: 2012-05-05
I started having some problems with some older Access apps that use the OutputTo command (RTF Files).   When running full Access, no problem, but when running Runtime (Same PC) I get Error 2578 "Can't Complete the Output Operation". (Or without the error trap, it will report) "The object type, name, or output format is invalid."

It's very intermittant. Some PCs will have a problem, others will not.
0
Comment
Question by:askolits
  • 8
  • 7
15 Comments
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
I don't know if this is the problem in your specific case, but here is the cause of the problem and the solution as posted in the public forums:

the runtime is looking for Utility.accda which is in the \Accwiz folder and which the runtime doesn't know about. Copying the file UTILITY.ACCDA from the ACCWIZ directory to the same directory as MSACCESS.EXE fixes the problem.

HTH
0
 

Author Comment

by:askolits
Comment Utility
I tried this on two PCs, but still a no go. It just showed up on another PC in a different program that's been running for years. Think there was some sort of patch that Microsoft did that starting to cause this error? Very frustrating.

 
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
If you are converting to Access 2007 RunTime, the following link will download sp1 which contains a fix for errors related to the OutputTo in Access 2007 Runtime.

              http://support.microsoft.com/kb/943249
If you are still using Access 2000 Runtime, and have not converted to Access 2007 RunTime, the only other thing I can think of is to make sure you don't have any missing vb library references, particularly to the DAO3.6 dll
0
 

Author Comment

by:askolits
Comment Utility
Actually, I am testing this with two runtime versions. One is created using the MSAccess tools, the other is created using the WiseINstalltion using the SageKey scripts. They both are bvased off Access 2000 runtime files.

DAO360.dll reference? Well, what's odd is that these applications have been running years without a problem, so they must have their refernces set correctly. The other issue may be that another program that has been installed (which is done regularly) may have placed a second DAO360.dll in some other folder and then registered it. Is it possible the app is confused on which DAO360.dll to use? For instance, I found a few on a PC in places like C:\windows\system32  or maybe the  "C:\Program Files\Common Files\Microsoft Shared\DAO. Think this could be the problem?
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
Not confused as to which one, but where to find it if it is in a different location then the location it was in when the reference was set, or missing altogether.
0
 

Author Comment

by:askolits
Comment Utility
"it if it is in a different location then the location it was in when the reference"

That's possible but remember, this is not an issue with the full version of Access, only runtime. You would think, if that was the issue, it would affect both.

Is there a way to find in the registry which one(s) have been registered and where they are. I did a search and had some hits on DAO360.dll, but cuoldn't figure out which was registered and which wasn't.

0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:askolits
Comment Utility
Actually, I was looking for a way to look in the registry itself to find which DAO360.dll has been registered in Windows and where it was located.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
I never monkey with the registry...too risky....the code I gave you should tll you what you need to know...

Here is something else you can try.....place a copy of DAO3.6 and any actively used OCX files in the same directory/folder as the database file. i understand that when access can't find a referenced file in its normal location, it checks for it tn the db folder before raising an error.
0
 

Author Comment

by:askolits
Comment Utility
"the code I gave you should tll you what you need to know..."

I don't quite agree. The code won't tell me whether the dll is registered or not within the Windows Environment, it just tells me that Access as referenced the file. I can unregister all those files and Access will still show them in the list. Wether or not the file is actually registered in the 'Windows Registry' is different then viewing it in the References dialog in Access. I'd like to find out if the file is actually regfistered when the Regsvr32 is executed. And if sucessful, where in the registruy that info is stored. I have no plans to change the registery, just get some info from it.


I'll try you other idea now.

0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
in re: registry, I don't know because I never monkey with it.
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
If you still having problems, try the OutputTo using the snapshot format.
0
 

Author Comment

by:askolits
Comment Utility
Unfortunately, I can't because they may need to fine tune the doc before the end up emailing it out. RTF is the only option
0
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
0
 

Accepted Solution

by:
askolits earned 0 total points
Comment Utility
Well, never really figured out the problem. If I do I'll try to add it to this question.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Supress Detail 4 17
Sum Max help (Add 1 Month) 3 18
Numbers are exporting as text 5 24
MS Access query date sorting question 7 11
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now