Make Table query on ODBC table changes NULLs to empty strings in Access 2002
From: Les Mercer (lmercer_at_pavilionhg.co.uk)
Date: 06/29/04
- Next message: Simon Dowse: "Query Query"
- Previous message: Newbie: "Re: Queries filling up SQL server!"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 10:01:12 +0100
This is a change of behaviour between Access 2000 SP3 and Access 2002 SP3.
I have Progress table that is linked via ODBC into Access using OpenLink
Lite for Progress 9.0b. For over a year, using Access 2000 under Win98, I
have been running a Make Table or Append query against this ODBC table and
producing an extracted Access table. Any fields that are NULL on the source
ODBC table show as NULL on the output table. The query also has an
expression which tests a field for NULL. This also works
Running the same Make Table or Append query in Access 2002 SP3 under WinXP
Professional SP1, the expression does not find the NULL fields and the
output fields that should be passed across as NULL are set to zero length
strings.
If I change the query from a Make Table to a Select Query, the expression
correctly recognises the NULLs and the fields are reported as NULLs.
The problem does not occur if the source is an Access table, it seems to
only be when it is a linked ODBC one.
Has anyone else experienced this, and is there any alternative other than
checking and changing every query?
Les Mercer.
- Next message: Simon Dowse: "Query Query"
- Previous message: Newbie: "Re: Queries filling up SQL server!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
