Accessing MSAccess db with ODBC - column titles format
Posted on 2000-05-02
I'm having problems accessing particular columns in a MSAccess db table, if the column titles contain gaps, commas etc. For example, to retrieve data from column called "Ready for T/O" I'm using the following formula:
@DbLookup("ODBC";"U2STAT";"";"";"sh1";"Ready for T/O";"p3";"684" )
and notes returns an error. The only way how to make it work I found, is to go to the Access db and rename the column into "Ready_for_TO". It is pretty annoying when the db contains some queries, forms etc... - you have to change them as well and the owner of the database is not always willing to do that..... Is there any trick how to enter the column title into the formula, so that notes would accept it?
Thanks a lot!