Can I force datatypes with ADO?

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.

My question:

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.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!