How can a add fields to a database

[Inhumanoid]

How can I add a field(as the last field) to a table in a database with a vb-app

I'm using DAO

[This message has been edited by Inhumanoid (edited 01-21-2000).]

[netSurfer]

I think it's like this.

dim dbsData as database, rcdTable as recordset

set dbsData = OpenDatabase("data.mdb")
set rcdTable = dbsData.OpenRecordset("Select * from table")
rcdtable.Fields.Append table_info_as_object

The last part I'm unsure of. I don't have help for this computer so am not sure of that part of it. I do know that the fields.append is the proper function to use. Hope this helps.

[Clunietp]

http://www.vb-world.net/ubb/Forum3/HTML/002675.html

[MartinLiss]

Or better yet, (if I do say so myself) see my response to another post. Which is a complete, working procedure.

------------------
Marty
Can you buy an entire chess set in a pawn shop?


[This message has been edited by MartinLiss (edited 01-21-2000).]