>Hi ALL,
>
>I need to read / write to an ACCESS database.
>
>I run into follwing:
>
>A column is named, as reported by SQLCOLUMNS(...,'Native'),
Field "C".
>
>How do I adress this in a CA?
>SELCTCMD is like 'SELECT Table.[Field "C"] FROM Table'
>I get SQL error 1526
>Error in expression
Table.[Field [C]]>
>
>So something maps "" to [] but obviously it's not in the acces table.
Catch the select statement and set it manually in the CA object, with quotation marks. That should work around the automatic translation of Access crap names.
>Please don't argue about the field names. It's not a design of mine ...
If you ever created anything in Access, the secret will remain buried in the annals of UT, don't worry.