adding a new field to sql backend with VB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LadyCES - 29 Nov 2005 21:01 GMT

I have a client with an access 2002 frontend linked to a sql backend. I need
to add a new field to the sql backend from access. I'm new to sql backends
and work offsite so I don't have access to their sql server. I am tring to
set up a wrkodbc.connection but am not sure of the commands to then add a new
boolean field. Thanks,

Christine

Reply to this Message

Sylvain Lafontaine - 30 Nov 2005 04:30 GMT

Hi, this newsgroup is about ADP project and not about MDB files with linked
tables to a SQL-Server; so perhaps this is not the best place to ask a
question about WrkODBC.Connection.

However, the easiest way to alter a table would be to create from Access a
new ADP project linked to the SQL-Server and use the design tools of ADP to
make your alterations.

You can do it from DAO or ADO by running something like the following SQL
command:

ALTER TABLE [dbo].[Table1] ADD
[aa] [int] NULL CONSTRAINT [DF_Table1_aa] DEFAULT (0),
[bb] [int] NOT NULL CONSTRAINT [DF_Table5_bb] DEFAULT (0), ...

However, I don't remember how to do this with DAO.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I have a client with an access 2002 frontend linked to a sql backend. I
>need
[quoted text clipped - 7 lines]
>
> Christine

Reply to this Message