> Does anybody know how to insert and rename columns in an Access 2000
> database via VB6?

> I have some clients that have mdb files that need to be updated, but they
do
> not have Access 2000 in their systems.  I intend to send them an
executable
> that will look for the mdb file and update it as needed.

> Any help will be greatly appreciated.

> Fausto Lopez

> Connect to the mdb-file with ADO-Commands (just search the MSDN for
connect
> and/or open). Then you can modify the database with sql-queries (something
> like ALTER TABLE ...).
> If you need further info then just post again (I would have to look it up
;)

> Gru? Robert

> > Does anybody know how to insert and rename columns in an Access 2000
> > database via VB6?

> > I have some clients that have mdb files that need to be updated, but
they
> do
> > not have Access 2000 in their systems.  I intend to send them an
> executable
> > that will look for the mdb file and update it as needed.

> > Any help will be greatly appreciated.

> > Fausto Lopez

> Thanks for the input Robert.  Connecting, opening, and modifying content of
> existing records is no problem for me.  I just haven't found any information
> on how to insert new columns or rename existing ones.

> Thanks

> Fausto Lopez

> > Connect to the mdb-file with ADO-Commands (just search the MSDN for
> connect
> > and/or open). Then you can modify the database with sql-queries (something
> > like ALTER TABLE ...).
> > If you need further info then just post again (I would have to look it up
> ;)

> > Gru? Robert

> > > Does anybody know how to insert and rename columns in an Access 2000
> > > database via VB6?

> > > I have some clients that have mdb files that need to be updated, but
> they
> > do
> > > not have Access 2000 in their systems.  I intend to send them an
> > executable
> > > that will look for the mdb file and update it as needed.

> > > Any help will be greatly appreciated.

> > > Fausto Lopez