alter table in access code

  • Thread starter Thread starter 00KobeBrian
  • Start date Start date
0

00KobeBrian

How can I issue an "alter table" command in a code in Access 97 ? THanks.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not receiving forum emails 14
ALTER COLUMN Help 8
Access Access VBA question 0
How to export table from outlook into ms access table? 0
copy data from 1 table to a second table 2
Color Codes Decipherable? 3
in a form, I can't alter data pulled from a query 2
Access Access Column Heights 0

Back
Top