By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,015 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Make Table query on ODBC table changes NULLs to empty strings in Access 2002

P: n/a
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!
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.