Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

While in Access Runtime OutputTo Fails

Posted on 2008-10-29
15
Medium Priority
?
952 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
ID: 22839905
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
ID: 22840370
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
ID: 22841218
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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 

Author Comment

by:askolits
ID: 22841378
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
ID: 22841497
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
ID: 22841577
"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
ID: 22841664
0
 

Author Comment

by:askolits
ID: 22841725
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
ID: 22841976
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
ID: 22842070
"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
ID: 22842165
in re: registry, I don't know because I never monkey with it.
0
 
LVL 38

Expert Comment

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

Author Comment

by:askolits
ID: 22844605
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
ID: 22845446
0
 

Accepted Solution

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

783 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