INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Alter Table

Alter Table

(OP)
Want to rename a column in a table. Tried using this:

CODE

    sChkField = "Birthdate"
    If FieldExists(rs, sChkField) Then
        sAlter = "ALTER TABLE Members RENAME COLUMN BirthDate TO DOB"
        cn.Execute sAlter
    End If

Private Function FieldExists(r As ADODB.Recordset, sFieldName As String) As Boolean
    Dim fld As Field
    sSql = "SELECT * FROM Members"
    rs.Open sSql, cn

    For Each fld In r.Fields
        If fld.Name = sFieldName Then
            FieldExists = True
            Exit For
        End If
    Next fld
    r.Close
    Set fld = Nothing
End Function
 But it does not accomplish that task. Any ideas?

Thanks.
 

RE: Alter Table

Try something like

CODE

Dim fd    As ADOX.Column
Dim cat   As ADOX.Catalog

Set cat = New ADOX.Catalog
Set cat.ActiveConnection = CurrentConnection
Set fd = cat.tables.Item("members").Columns("BirthDate")

fd.Name = "DOB"

Set fd = Nothing
Set cat = Nothing

RE: Alter Table

(OP)
Thanks for the reply. Which Component/Reference needs to be added?

RE: Alter Table

(OP)
Works, thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close