How to add a new coloumn in Access table thru foxpro 8

Cindy Winegarden

2005-02-11 21:23:58 UTC

Hi Zahid,

Sorry I don't have a machine without Access, or an Access 97 MDB to test
with. Have you tried the SQL Alter Table command? I did find one newsgroup
post:
Jon Dec 9 2001, 10:02 pm show options

Newsgroups: comp.databases.ms-access
From: ***@aol.com (Jon) - Find messages by this author
Date: 10 Dec 2001 06:01:42 GMT
Local: Sun, Dec 9 2001 10:01 pm
Subject: Re: Access 97: ALTER Table ALTER Column Question
Reply to Author | Forward | Print | Individual Message | Show original
| Report Abuse

- Hide quoted text -
- Show quoted text -

I want to create a query in Access 97 that will change the data type of a
particular field from Text to Currency. I thought the correct syntax would
ALTER TABLE Table1 ALTER COLUMN Field1 Currency
I get a syntax error and the second ALTER is hilited.
Any ideas?
thx,
Mike

Mike

This syntax is only supported in Jet 4 (ie Access 2K/AXP). In A97, if you
wish
to change the datatype of a column, you must add a new column with the
correct
properties, insert the data from the old column, then delete the old column,
and finally rename the new column.

Jon
<<
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP

Hi Guys,
I am working on Access 97 Database and need to add a new coloumn in one of
the tables existing in access database. I dont have copy of Access 97.
Please guide me if there is any way to add a new coloumn or if there is any
way to change the structure of tables in Access using VFP8.
Thanx.
--
_________________________________________
Zahid Maqsood