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?