Additional Fields in a table

Using VS 2005, access db.

I have a maintenance program that uses the 'INSERT INTO' statement.

I know at some time in the future I will need to add more fields to table.

Is there a method of programming that can be used so a recompile would not be necessary. (assuming I am not maintaining these fields in the program).

I was thinking of something like a xml file.

Any thoughts would be welcome.

Thanks in advance.

[458 byte] By [Can-Ann] at [2007-12-22]

# 1

Assuming you store the table structure in a file of sorts, how would ypi get your application to set the field values during the insert operation?

Not only would you need to get the list of fields in the altered table, but you'd need to know what to do with that list.

What would you do if you added a date or integer field, your SQL statement would be slightly different in either case.

ZahirJ at 2007-8-30 >

# 2

Thanks - I guess I had not thought this all the way thru.

Can-Ann at 2007-8-30 >

Visual C# Hot Topic