User Defined Table Creation

[jboyle]

Is there a way to build a table based on the users input?

I would like to construct a form that prompts the user to input whatever items he so likes. Each of these items that he types in would become a field name in a new table.

In other words, I want to create a table without having the user go into Access design mode.
Thanks in Advance - John

 

[kaspi]

Hi John
You can create table at runtime. You have several options:
1. You can use SQL - check CREATE TABLE statement
2. You can use DAO - check CreateTableDef method
3. You can use ADO (ADOX - Microsoft ADO Extensions 2.1 for DDL and security)
Kaspi