If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
alter table in access code
How can I issue an "alter table" command in a code in Access 97 ? THanks.
|
#2
|
|||
|
|||
alter table in access code
"00KobeBrian" wrote in message
How can I issue an "alter table" command in a code in Access 97 ? THanks. 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. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
#3
|
|||
|
|||
alter table in access code
"00KobeBrian" wrote in message
How can I issue an "alter table" command in a code in Access 97 ? THanks. 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? -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|