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,

Vince. 

-----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