<div>
Yes, it was there all along. I expected it to be called adMemo or something. I've just tried it and it works fine.<br />
<br />
Thanks for your help guys.<br />
<br />
Oan
</div>


Yes, it was there all along. I expected it to be called adMemo or something. I've just tried it and it works fine.

Thanks for your help guys.

Oan

<div>
<div class="content wysiwyg-content">
I'm using ADOX to create a local table in order to cache records from my SQL Server database. I'm writing my code so that the table will automatically be deleted and recreated should the structure of the SQL Server table change.<br />
<br />
One field in the SQL Server table is declared as varchar(500). Because of the size, this means that a memo field is necessary in my Access table. My problem is that there doesn't appear to be a constant available to declare the Memo data type in ADOX. Here's the list of data types I am using. Is it incomplete?<br />
<br />
<a href="http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B266302" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B266302</a><br />
<br />
Ian
</div>
</div>


I'm using ADOX to create a local table in order to cache records from my SQL Server database. I'm writing my code so that the table will automatically be deleted and recreated should the structure of the SQL Server table change.

One field in the SQL Server table is declared as varchar(500). Because of the size, this means that a memo field is necessary in my Access table. My problem is that there doesn't appear to be a constant available to declare the Memo data type in ADOX. Here's the list of data types I am using. Is it incomplete?

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B266302

Ian

Creating Memo fields with ADOX

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.