0 00KobeBrian Sep 6, 2006 #1 How can I issue an "alter table" command in a code in Access 97 ? THanks.
D Dirk Goldgar Sep 6, 2006 #2 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... 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 Sep 6, 2006 #3 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?
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?
