You don't need ADOX for that, you can do it with ADODB ...
objConnection.Execute "ALTER TABLE tblTest ALTER COLUMN TestText Date"
.... where objConnection is your ADODB.Connection object
Or, as you mention C#, you can use ADO.NET ...
using System;
namespace TestAlterColumn
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ @"Data Source=\\ServerName\ShareName\FileName.mdb;"
+ "Persist Security Info=False";
string commandText = "ALTER TABLE tblTest ALTER COLUMN TestText Date";
System.Data.OleDb.OleDbConnection connection
= new System.Data.OleDb.OleDbConnection(connectionString);
System.Data.OleDb.OleDbCommand command
= new System.Data.OleDb.OleDbCommand(commandText, connection);
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (System.Exception ex)
{
Console.WriteLine(ex.ToString());
Console.ReadLine();
}
finally
{
connection.Close();
}
}
}
}
