adding fields or tables

[Alistair]

Access 2000

hi peoples,

is it possible to dynamically add a field into a table? or add a table?

Lets just say that I have a DB with 10,000 entries and about 5MB in size. I
want to add a new feature and for this i need to add an extra field to the
table. I don't want to d/l the DB, make the changes locally and then u/l
again, so can I do it via script?

many thanks



*..· ´¨¨)) -:¦:-
¸.·´ .·´¨¨))
((¸¸.·´ .·´
-:¦:- ((¸¸.·´* -:¦:- *Alistair * -:¦:-

[Bob Barrows [MVP]]

Re: adding fields or tables

Alistair wrote:[color=blue]
> Access 2000
>
> hi peoples,
>
> is it possible to dynamically add a field into a table? or add a
> table?
>
> Lets just say that I have a DB with 10,000 entries and about 5MB in
> size. I want to add a new feature and for this i need to add an extra
> field to the table. I don't want to d/l the DB, make the changes
> locally and then u/l again, so can I do it via script?
>[/color]

Open Access, press F1, click into the Contents tab, scroll down until you
see the Microsoft JetSQL Reference and look through it to find the SQL DDL
(Data Definition Language) commands you can use to add a field to a table.
(ALTER TABLE ... ADD COLUMN ...).

Alternatively, you can use ADOX. A quick search of www.aspfaq.com and
msdn.microsoft. com/library should get you plenty of info on using this
technology.

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"