I am faced with a situation that the user should be able to add and delete fields and name them.
How can I let him to it with a button leading to some vba?
thanks

This is an exceptionally poor idea and will be nearly impossible to implement using A2K (or newer) if you need to support multi-user access.

I suspect that the reason that you want the user to be able to add new columns is that you have created a maintenance nightmare for yourself by not normalizing your table structure. You have probably designed the tables much like you would have designed a spreadsheet. In a properly structured table, the user would ONLY need to add new rows to an existing table. He would NEVER need to add columns to an existing table.

What will happen with the queries/forms/reports if you allow users to add columns to tables? What good are the new columns if the only way he has of accessing them is by opening the table directly?

If you want help restructuring your tables, post a description of the existing structure and an explaination of what prompts the need to create a new column.