X-Received: by 10.107.169.88 with SMTP id s85mr2046280ioe.30.1455450383099; Sun, 14 Feb 2016 03:46:23 -0800 (PST)
X-Received: by 10.50.26.35 with SMTP id i3mr82873igg.7.1455450383015; Sun, 14 Feb 2016 03:46:23 -0800 (PST)
Path: csiph.com!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!news.glorb.com!hb3no4504408igb.0!news-out.google.com!l1ni13121igd.0!nntp.google.com!ok5no1588680igc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: it.comp.lang.visual-basic
Date: Sun, 14 Feb 2016 03:46:22 -0800 (PST)
In-Reply-To: <n9pifd$56t$1@solani.org>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=151.16.212.238; posting-account=eitZdgoAAAC6C9CXmyhLNaQM3MgI3eZM
NNTP-Posting-Host: 151.16.212.238
References: <n9pifd$56t$1@solani.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <ba25d574-75ff-4f27-9b4f-3d88f3ebf9cd@googlegroups.com>
Subject: Re: Rinominare un campo
From: Luca D <antaniserse@yahoo.it>
Injection-Date: Sun, 14 Feb 2016 11:46:23 +0000
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Xref: csiph.com it.comp.lang.visual-basic:18696

On Sunday, February 14, 2016 at 10:47:26 AM UTC+1, Greg wrote:
> VB6 + access
>=20
> Non riesco a cambiare il nome di un campo con l'istruzione:
> DB.Execute "ALTER TABLE Clienti2 CHANGE Anno2 Anno3 Date"
>=20
> Errore di sintassi nell'istruzione Alter Table.
> Sto sbagliango qualcosa o forse con access non =E8 possibile? Grazie
>=20
> --=20
> Greg

Via comando SQL non mi risulta sia supportato... se proprio devi farlo via =
codice, devi usare gli oggetti DAO/ADOX per manipolare le property di Table=
Def/Table