docmd.OutputTo errors

[Deb]

Docmd.Outputto is not working in Access 2002. I'm trying to export query
results to a txt file. I'm getting "not enough memory" errors when I have
the statement in VBA code. statement is "docmd.outputto acOutputQuery,
"qryxyz", acFormatTXT, , False". The query has an underscore in its name but
I renamed it without that and it still didn't work.
When I unhide the database, go into the query results and choose
File/Export, it complains about the query name or says it can't find it
(based on which output type I choose). This all worked in Access 2000 for me.

 

[John Nurick]

Hi Deb,

Does the query open satisfactorily and display the correct results when
you simply run it from the Database window? (i.e. you only get errors
when you try to export it). If so, can you export other queries from
that database, and/or queries from other databases?

If there are problems exporting queries from other databases then
suspect that something has gone wrong with your Access installation.
Confirm this by exporting the suspect query on another machine.

If the query doesn't open and display the correct results when you run
it from the Database window, or if queries from other databases work and
export properly, the database may have become corrupt. Make a copy of it
so you can't inadvertently make things worse, and see if a Compact and
Repair fixes it. If not, see Tony Toews's Corrupt Microsoft Access MDBs
FAQ at http://www.granite.ab.ca/access/corruptmdbs.htm

 

[Deb]

When trying to copy and paste query results I get an error from the
application that states "the setting for sao900.dll format in the Windows
Registry is incorrect". Have you heard of this before?
And to answer your question, other queries in the database dont' export
either.
This may be an application problem, not access 2002. Its a new version of
our app that is in .net and access 2002, vs. access 2000.
thanks.

 

[John Nurick]

I've never heard of sao900.dll, and nor has Google. If you mean
soa900.dll, it's part of the Office 2000 installation and has something
to do with exporting from Access (which certainly includes OutputTo and
I think includes pasting query results).

Office 97 had sao800.dll, but for Office 2003 and - I presume - Office
XP the file is just called sao.dll. So it seems there's a good chance
that there is indeed a problem in the registry. So the next thing to try
is to fire up Office XP setup and repair the installation.