Add a field to exist access table by ADO

[farhad]

Hi

In vb6 and access 2000 database , if we want to add a field in one of the tables, How can do if we want to use ADO , please tell code about. thanks

[CaptainD]

Hi

In vb6 and access 2000 database , if we want to add a field in one of the tables, How can do if we want to use ADO , please tell code about. thanks

I assume you are already doing inserts, updates through ADO so you have the connections.

If so, just pass an "Alter Table" SQL statement to the database. I've never done it to an access database, only SQL Server database but it should work.