Word 2003 receives no records from Access 2003 query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tor Michal Kinn - 07 Apr 2005 09:08 GMT

I got a query in Access 2003 (tried 2000 also).
When I run it in Access, it returns several records.

Then I try to merge it into Word or Excel 2003.
Then it return no records.

Any idea what the problem may be?

Reply to this Message

Peter Jamieson - 07 Apr 2005 11:26 GMT

Does your query use any wildcards (*%_?) in a LIKE clause?

If so, you are probably encountering the problem described in

http://support.microsoft.com/default.aspx?scid=kb;en-us;234525

and you may need to change the dialect of SQL that is being used in your
database - if so, just bear in mind that the impact of a change could be
large.

Peter Jamieson

>I got a query in Access 2003 (tried 2000 also).
> When I run it in Access, it returns several records.
[quoted text clipped - 3 lines]
>
> Any idea what the problem may be?

Reply to this Message

Rate this thread: