Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    1

    Unanswered: How to add fields

    Hi,

    I've been asked by some friends to give some DB help on an Access DB field they have, running on a server 2003 VPS through AT&T.

    They need a few fields added. Through AT&T there is no control panel to the DB, just a place to setup the DSN. There isn't local access to the machine, since it's a VPS through someone else, to run Access on.

    So would someone typically add fields to a DB? With MySQL (Which I"m much more familiar with) I would just load up something like phpmyadmin, or something similar. Or even do it from the CLI..

    Thanks
    David

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you don't have direct access the db then you could execute a form which issued DDL to alter tables

    eg
    Code:
    alter myatble
    add mycolumn int
    http://www.vb123.com/toolshed/99/createtables.htm

    and run it inside a form with a do cmd.exec
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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