Results 1 to 3 of 3

Thread: [2005] Chaning a MDB table

  1. Sep 5th, 2007, 06:49 PM #1
    kiwis
    kiwis is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2003
    Location
    Auckland
    Posts
    1,139

    [2005] Chaning a MDB table

    Can I add/edit/delete feilds in a .mdb database?

    If so how?
    Reply With Quote Reply With Quote
  2. Sep 5th, 2007, 08:32 PM #2
    Rocketdawg
    Rocketdawg is offline
    Hyperactive Member Rocketdawg's Avatar
    Join Date
    Feb 2003
    Location
    Back in the doghouse
    Posts
    294

    Re: [2005] Chaning a MDB table

    Hi

    A wee dangerous. You'll want to back up or make a backup of the table as sql can be a bit unforgiving. Try using sql view in Access to test it out on something not important first.


    Alter Table SomeTableName
    Drop Column SomeColumnName

    Alter Table SomeTableName
    Add Column SomeColumnName Datatype

    I believe you can't delete an identity column, but you could alway make a new table.
    Reply With Quote Reply With Quote
  3. Sep 6th, 2007, 03:47 PM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: [2005] Chaning a MDB table

    http://www.vbforums.com/showthread.php?t=466658
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width