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).]
Printable View
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).]
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.
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).]