Results 1 to 4 of 4

Thread: How can a add fields to a database

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 1999
    Posts
    309

    Post

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

  2. #2
    Hyperactive Member
    Join Date
    Jun 1999
    Location
    Calgary Alberta
    Posts
    359

    Post

    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.

  3. #3

  4. #4
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,175

    Post

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width