Access fails export query to XML

[vinz]

Hi all,



I have been having major issues with Access exporting queries.
Many, many issues. In fact I am very surprised that I don't see tons of posts around with poor users swearing to Microsoft, as I would do.

All the failing queries look just fine when in datasheet view. The Access engine can resolve them, problems occur when queries are interpreted by some other engine to make the export.
If a query yelds results internally but fails in export, to me is a bug.

If I make tables of these queries and export the table all is fine, if I export the query all I get is this

<?xml version="1.0" encoding="UTF-8"?>
<dataroot generated="2012-01-16T17:16:48" xmlns:od="urn:schemas-microsoft-com:officedata"/>

Why can I export tables but not queries?

Sometimes I find the troubling field in my query. Suppose

IIf([somefield] Is Null,"somestring","some other") AS [TroubleField]

If I change it into

IIf([somefield] Is Null,0,1) AS [TroubleField]

then it all works. It's useless, but works. This doesn't make much sense to me.

So my question is, has this occurred to anyone else, or am I alone in my world of pain? Anyone has figured out what is going on?

Thank you,
vinz

[brianscook]

Hi all,

I have been having major issues with Access exporting queries.
Many, many issues. In fact I am very surprised that I don't see tons of posts around with poor users swearing to Microsoft, as I would do.

All the failing queries look just fine when in datasheet view. The Access engine can resolve them, problems occur when queries are interpreted by some other engine to make the export.
If a query yelds results internally but fails in export, to me is a bug.

If I make tables of these queries and export the table all is fine, if I export the query all I get is this

<?xml version="1.0" encoding="UTF-8"?>
<dataroot generated="2012-01-16T17:16:48" xmlns:od="urn:schemas-microsoft-com:officedata"/>

Why can I export tables but not queries?

Sometimes I find the troubling field in my query. Suppose

IIf([somefield] Is Null,"somestring","some other") AS [TroubleField]

If I change it into

IIf([somefield] Is Null,0,1) AS [TroubleField]

then it all works. It's useless, but works. This doesn't make much sense to me.

So my question is, has this occurred to anyone else, or am I alone in my world of pain? Anyone has figured out what is going on?

Thank you,
vinz

I haven't been able to find any help at all yet...I know this doesn't help, but surely someone has an answer. In my case, my query produces no NULL fields. Thanks