p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

vba_access thread: SQL statement in VB for Access

Message #1 by "mike wilson" <chopswil@h...> on Tue, 17 Jul 2001 15:12:40
I don't think you'll be able to do this in one go, I would try:

SQL1. ALTER Table ADD Column Field Type and size
SQL2. UPDATE query and move records to new column
SQL3. ALTER Table DROP original column.

Best Regards,


-----Original Message-----
From: mike wilson [mailto:chopswil@h...]
Sent: 19 July 2001 15:44
To: VBA_Access
Subject: [vba_access] Re: SQL statement in VB for Access

Tried it, didn't work. Same error

Mike Wilson

> Hello, 
>  You can write u'r query to modify u'r column..
> sChangeDB = "alter table Address alter column " _
>               & "[Street]" & " text(40)"
> I think u will succeed with this code...
> Bye

  Return to Index