add/remove field from MS Access

[John]

Hi!
I am a newbie in ASP. I would like to use ASP to access a data base (MS
Access).
However, the db is not so normal. What I mean is that from time to time I
want to add or remove fields from a table.
I would like to do it using code and not from the design view of MS Access.
Is that possible?

Thnx in advance

[Bob Barrows]

John wrote:

> Hi!
> I am a newbie in ASP. I would like to use ASP to access a data base
> (MS Access).
> However, the db is not so normal. What I mean is that from time to
> time I want to add or remove fields from a table.
> I would like to do it using code and not from the design view of MS
> Access. Is that possible?
>
> Thnx in advance

I recommend that you rethink this design. It will cause you nothing but
headaches down the road. A properly normalized database should never need
these types of activity when in production. It sounds to me as if you are
trying to use the database as if it was an Excel spreadsheet. You are
definitely missing out on the power of a relational database if you treat it
as if it was a big spreadsheet.

However ...

You have two options:

1. You can use SQL queries to modify table structures. Look up the JetSQL
section in Access online help for details. The easiest way to find this
section is to go to the Contents tab in the online help window, expand the
main node if it's not already expanded, and look for the node titled
Microsoft Jet SQL Reference. The subnode titled Data Definition Language is
the relevant section.

2. You can also use ADOX to do this. Go to
[url]http://msdn.microsoft.com/library/en-us/ado270/htm/pg_adox_fundamentals.asp[/url]
for details.

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"