Path: archiver1.google.com!news1.google.com!newsfeed.stanford.edu!bloom-beacon.mit.edu!nycmny1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!opentransit.net!wanadoo.fr!not-for-mail
From: =?ISO-8859-1?Q?Val=E9rie?= Labonne <s...@caramail.comm>
Newsgroups: comp.databases.ms-access
Subject: foreign key
Date: Thu, 25 Jul 2002 09:21:24 +0200
Organization: Wanadoo, l'internet avec France Telecom
Lines: 23
Message-ID: <3D3FA6F4.3080701@caramail.comm>
References: <3D3EBD33.1060701@caramail.comm> <6jttjuk7bv8ddshiv9u319jnoeje9piugg@4ax.com>
NNTP-Posting-Host: abordeaux-103-2-2-17.abo.wanadoo.fr
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: wanadoo.fr 1027581262 23034 193.251.6.17 (25 Jul 2002 07:14:22 GMT)
X-Complaints-To: abuse@wanadoo.fr
NNTP-Posting-Date: 25 Jul 2002 07:14:22 GMT
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr-FR; rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3
X-Accept-Language: fr-fr

ok thx


Chuck Grimsby wrote:

> You can't alter a column's datatype in access via a query.
> 
> You have to alter the table to add in a new column,
> use a update query to move the data over to the new column,
> then another alter query to delete the old column.
> 
> On Wed, 24 Jul 2002 16:44:03 +0200, Valérie Labonne
> <s...@caramail.comm> wrote:
> 
>>Is there a way in access to alter the datatype of a column with an SQL 
>>query?
>>eg:
>>alter table alter column set ...
>>It doesn't seem to work. Anyone has an idea?
>>
> 
>