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?
LesM
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!