This ability to use ODBC with access is pure magic! I created a database on the Access machine, and in that I created a table, with a memo field. I exported the table to the postgres database. I looked at the structure of the table in pgsql, and the memo filed is type TEXT of var length. As it says in the docs. magic. I love it. I deleted the table from the Access database, then Linked the same(new) table from the pgsql database, so I can populate it from the Access machine. pure magic. so, apart from my enthusiasm for this deal.... Memo fileds become unlimited length TEXT fields. ( Well I don't know about unlimited, but big enough I guess.) bob -- http://www.chalmers.com.au. Publications From China in 24 different languages. English, French, German, Russian, Arabic, Spanish, Chinese, Burmese, Bengali, Hindi, Indonesian, Italian, Japanese, Korean, Portuguese, Persian, Swahili, Sinhalese, Thai, Tamil, Urdu, Vietnamese. China Books for CIBTC, Beijing.
