Posted by Chung Leong on 10/09/56 11:56

Costas Menico wrote:
> I have an Access database and a table. One of the columns was a memo
> field. If I execute a 'select * from table', all the rows would be
> retrieved but the columns after the memo column had null data.
>
> If I moved the memo field to the end and executed the same SQL the data
> was retrieved propery.
>
> Also if I specified the column name by itself (E.g. select phone from
> table' ), the data was retrieved.
>
> Has anyone seen this kind of problem with any other databases where a
> memo field must be the last one?

That's a known limitation of ODBC I think. Once the driver goes into
blob retrieval mode, it can't retrieve fixed width columns anymore.

[Back to original message]