alter table in access code

D

Dirk Goldgar

00KobeBrian said:
How can I issue an "alter table" command in a code in Access 97 ?
THanks.
Click to expand...

You can execute it like any other SQL statement:

DoCmd.RunSQL "ALTER TABLE ..."

or

CurrentDb.Execute "ALTER TABLE ..."

Or you could manipulate DAO objects to modify the table, but that's more
complicated.
 
D

Dirk Goldgar

00KobeBrian said:
How can I issue an "alter table" command in a code in Access 97 ?
THanks.
Click to expand...

BTW, why did you crosspost this to .reports? It doesn't seem relevant
to that newsgroup. It's not terribly relevant to any of the groups you
posted it to; why not to .modulescoding or .modulesdaovba instead?
 
Top