[AccessD] Alter Table

Probably. ALTER TABLE's ok, it's the ALTER COLUMN bit that isn't.
 
Still, hopefully you've helped Tracy who put the original question.

Andy Lacey
http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/> 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 13 April 2003 17:35
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Alter Table


Andy, I really don't know what it doesn't work in 97 -- it's straight
basic SQL and it isn't an extension, but I guess it's possible that
ALTER COLUMN is new to the more recent version of SQL. 
 
Susan H. 



No, still get a syntax error. And I don't think pass-through queries are
an option when you're updating a linked MDB, are they?
 

Oh wait. It's an A97 problem. Works in A2K but not A97, which is pretty
much all I use, so that's my excuse for my ignorance. Well, Tracy,
hopefully Susan's solved it for you. As for BEU, mmmmm...........
 
============It should work in 97 too, you may just need a different VBA
route -- try it via the SQL window. 
 
Susan H. 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030413/0e5507bd/attachment-0001.html>