Solved

While in Access Runtime OutputTo Fails

Posted on 2008-10-29
15
929 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to line 23 55
Display 2 columns in combobox view 8 30
UK Date format in MS Access 4 25
2 subforms 1 main form 1 15
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

821 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