Yes.I really don't know where to look.Do you have an access fan friend?

No difference
I'm really planing to do sth with bill gates.

I wrote your code exactly in the macro definition but I got the same error message.then I changed it to:
ALTER TABLE 'Forms![Form1]![tname].text' ADD COLUMN 'forms![form1]![fname].text'...

This is my macro definition:

But when I run it,I get the error below:

Ok.Now I have just one more question.
I created a form and a macro.the macro is a runSql with alter table statement.I just want to use the text boxes of the form for the table name,field name and...

You know I'm not really good in access so could you tell me where should enter that command and how to connect it with the submit button?

Yes I'm going to let the user add a new field to the table but Its not a real world database.

Hi
I want to know how can I make my database that the user can add a field to a table from a form or sth?
thanks