Adding Fields to MS Access Table

[sytech]

Hi

I am new to Delphi and have a problem changing Table field names programmatically, checked the FAQ's etc found lots of useful info but not the answer to my problem.

I have several MSAccess tables which I need to add a column to also I need to change some existing field names, the tables are on remote stand alone machines and would be updated by sending a CD to the Site.

Any Ideas is it possible?

Thanks in anticipation.

 

[DaZZleD]

one way I did this was using sql statements. use the following query to add columns to a table:

'alter table [tablename] add [colname] [coldefinition]'

then apply the query to the db you want with the params you want. should be possible through delphi's table component but i never really bothered. i like using sql more

 

[sytech]

Thanks D I will give that a try.