2 ASP questions

[Bios]

1.) In an access database I know how to add a row, but how do you add a new column to a table in the database?

2.) I know a little about Scripting.FileSystemObject, but am just now using it for the first time. I know how to use createtextfile to write to a text file, and opentextfile to read to a text file...I was wondering if opentextfile can be used to write to the end of the file. Also if there is a way to remove a line from a file with out reading each line into an array then writting it again... any input about reading and writing a text file would be helpful.


Thank you for any help in advance,

i just have the answer for your first question;

for example

ALTER TABLE ANTIQUES ADD (PRICE DECIMAL(8,2) NULL);

good luck