I've been trying to dynamically add fields to an existing Access
database/table using ADO and Microsoft Jet as my provider, without
success. The table already contains some fields, and I desperately need
the ability to add more based on user input. Can anyone give me a hand
with this one?

Thanks a MILLION in advance,
Jason Peter Brown.

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

Look up ALTERTABLE SQL statement and CreateField.  These commands do what you're
after.

The example in ALTERTABLE is one of adding a field to a table.

Mianne.

IE:  instead of having a table looking like this:
TABLE CUSTOMER
Firstname
Lastname
Street
City
Zip

and I want to add a field Phone Number, I would instead break it into 3 tables:

TABLE CUSTOMER
customerID

TABLE INFO_TYPE
infotypeID
infotype_description

TABLE CUSTOMER_INFO
customerID
infotypeID
value

This format allows me to add unlimited information types and unlimited
information about the customers, without modification to the underlying database
structure.

Just a thought.

--
 ----------------------------------------------------------------------------
|          Jeff Goslin - Monument           | "Oh Bentson, you are so        |

|                                           |  ravages of intellect."        |
|   http://www.acs.oakland.edu/~jggoslin    |   --Evil, The Time Bandits     |
 ----------------------------------------------------------------------------
|   how come everyone elses religion is a cult but your cult is a religion   |
 ----------------------------------------------------------------------------

If you really do want to alter an existing table you can try the Alter
statement as suggested or you can use the ADOX object (something
like "Microsoft ADO Ext n for DDL and Security" in project/references)
See http://www.microsoft.com/data/ado/adotechinfo/dao2ado.htm
for comparisons between DAO and ADO including some examples of thi sort
of thing
--
Please reply via the newsgroup only

Sent via Deja.com http://www.deja.com/
Before you buy.