Thanks for the reply, Andy.
> ALTER TABLE table
> { [ALTER COLUMN column_name
[snip]
> to ensure it works ok.
I appreciate what you say about SPs but this on an Access database and I've
never used SPs.
Unfortunately the machine the DB is on doesn't have Access installed (it's a
network admin thang ;-), hence the need to do this via SQL statements.
Would the SQL statement be something like (guessing here):
ALTER TABLE TableName {ADD NewColumnName AS OldColumnName} ???
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
