User Defined Table Creation

[jboyle]

Is there a way that a form would ask the user what information they want to track. For example: the form would ask to enter what they want to track. The user types in people. The form then ask what else. And the user types in hours worked. And on and on and on until the user has defined all items he wants. I want the items entered by the user to make up the table filed names.
Thanks - John

 

[Chris RR]

I think that maybe your users belong in plain vanilla Access. Especially if they need to define field types or what have you.

Normally, you set this stuff up for users, because it's assumed that you understand the best way to do this from the system's perspective. You would be able to protect the user from creating a sluggish monster...or an irretrievable mess...and would come up with a system that is maintainable, expandable, integratable. That's why programmers command such love & respect, fantastic salaries, and other perks...

...but, if I were going to cheat a little, I'd set up a dummy table for the users, with, say, 15 fields (Field1,Field2, etc.) plus some key. Then I'd have another table to contain the user-defined field titles (F1_Title, F2_Title, etc). If you linked the two together, the user could always request their "title" for a field, and you could always print things to look like they'd expect. They'd never know that you were in control.