alter table in access code

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
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.
 
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?
 
Back
Top