Re: Question about ALTER TABLE and ALTER COLUMN
- From: "Kevin Jameson" <no_spam@xxxxxxxxxx>
- Date: Tue, 19 Sep 2006 09:06:46 -0500
you cant do this with microsoft access 2003
you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html
HTH
Kevin
"BobV" <rkvjr.IGNORE@xxxxxxxxxxxxx> wrote in message
news:1fSPg.3487$UG4.2842@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Group:
I am using Access 2002. I want to add a column to a table (MasterData) in
the backend database and then specify that it be an integer with a default
value of zero. I am using the following statement to add a column to the
MasterData table, but I would like to further specify that the column be
an integer with a default value of zero. Can someone suggest the proper
syntax for a VBA statement to do what I want to do? I think I need to use
ALTER COLUMN but I don't know the proper syntax. Any sample code would be
greatly appreciated.
BackDb.Execute "ALTER TABLE [MasterData] ADD COLUMN [CompanyOpen] Number;"
Thanks,
Bob V
.
- References:
- Question about ALTER TABLE and ALTER COLUMN
- From: BobV
- Question about ALTER TABLE and ALTER COLUMN
- Prev by Date: Re: OLE Object
- Next by Date: Re: Access list box
- Previous by thread: Question about ALTER TABLE and ALTER COLUMN
- Next by thread: Re: Question about ALTER TABLE and ALTER COLUMN
- Index(es):
Relevant Pages
|
