Using ADO to append an Access field

[JeffCarlin]

We distribute an app that allows users to use either Access or SQL Server as the database. From time to time, we may have to modify the database. Since "ALTER TABLE" will not work with Access, can someone give me a way to do it? BTW, the Access db is password protected.

Thanks

 

[edderic]

!!!!!!!

With ADO 2.6 its works fine on Access databases.

Detec.Execute "ALTER TABLE tempProduktie ADD COLUMN BarcodeText TEXT(50)"

Eric De Decker
vbg.be@vbgroup.nl

 

[petermeachem]

And for much longer than that. Think vb3 and access 2.
Why do you think it doesn't work? Peter Meachem
peter @ accuflight.com