Append column in run time

[Doron Barnea]

Hi,

As a result of version enhancments, I need to perform an upgrade to existing access DB. This upgrade involves adding a new column to an existing table.

Tried ADOX and ADO.NET with no success ...

Anyone knows how to do it ?

Thanks,
Doron.

 

[jmcilhinney]

You should be able to use ADO.NET. You just need to know the correct SQL statements and then call OleDbCommand.ExecuteNonQuery. I haven't ever tried this myself but I believe it should work. If not, your next step would be automation. Lookup "automation access" on MSDN. Most examples you'll find of Office automation are for Word, Excel or Outlook, but it's just as possible with Access.