Jason,

I am using A2K/ WinXP

I used your SQL and I did not get an error. I changed the field from 50 to
10, then to 55, then to 35..... no errors.

Are you using any special chars in the table name or field name???
Is the column you are trying to alter TEXT??

Try changing your code to:

Dim sSQL as string

  ' this should be one line
  sSQL = "ALTER TABLE [" & vTableName & "] ALTER COLUMN [" & vFieldName &
"] TEXT (" & vParameters & ")"

 ' find out what is in the string sSQL
 Debug.Pring sSQL

  db.Execute sSQL, dbFailOnError

Set a breakpoint on the "db.Execute" line and post back with the sSQL
results (from the immediate window)

HTH

Jason,

I have also tried it and it works OK (which is not really surprising
as it is my code you are using). However, I noticed on one of your
other posts that you are using Access 97 and I am wondering if this is
the problem. I know that Microsoft made quite a few enhancements to
the SQL Jet Engine between versions 97 and 2000 and it may be that the
ALTER COLUMN function did not have this facility on the earlier
version. Also, looking at my old Access 97 books, I don't see any
commands to change the field size. Maybe someone else has more info on
the changes made.

Is it possible for you to try the code out with Access 2000 (or later)
to see if it works then.

There is some information on SQL 97 at :-
http://www.personal.kent.edu/~gthomas/sql/sqldoc.htm#altertable
No mention of changing the field size on an existing field, although
you can set the field size when adding a new field to a table. You
could delete the field with the DROP command and then add it in again
but you would lose any data in the field (which would not be a good
idea).

Also this site has more information on SQL 2000 which may be useful :-
http://www.personal.kent.edu/~gthomas/sql/sqldoc.htm#altertable

HTH

Peter Hibbs.