Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Thanked 0 Times in 0 Posts

    change the name of the field (Access 2000)

    how can i change the name of the field with sql ? I have the code for changing the text into number : strSQL = "ALTER TABLE Preislist ALTER COLUMN crates FLOAT"
    But how can i change the the name of the field, for example "Lists" into "crates" ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: change the name of the field (Access 2000)

    You cannot rename a field once it has been created. The way to do it is:
    1) Create a new field with the new name using ADD COLUMN
    2) Run an update query to copy the data from the old field to the new field
    3) Delete the old field using DROP COLUMN

Posting Permissions

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