I have several PostGreSQL views linked into an Access database.
My queries require several joins.
The original views have data types of 'memo' in the fields that I need to join.
What I've done is make a create-table query which mimics the linked table. I then have to manually open the newly-created table and change the data type fields from memo to text in order for my queries to run.
Is there a way to programmatically (either ADO or VB) force the data types on the created tables from memo to text?
Thanks in advance for all of your help.