rename access field

Results 1 to 2 of 2

Thread: rename access field

  1. #1
    Join Date
    Dec 1969

    Default rename access field

    I have been trying to rename an Access field.<BR>I&#039;ve tried:<BR>SQL = "Alter Table [T1] Rename Column [C1] To [C2]"<BR>and<BR>SQL = "Alter Table [T1] Alter Column [C1] Rename To [C2]"<BR>with no luck.<BR>Does anyone know the syntax to rename a file in access?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default the docs?<BR><BR>See any place there where it even hints that you can do that?<BR><BR>I sure don&#039;t.<BR><BR>Best you could do would be to add a new column, copy the contents of old to new, drop the old.<BR><BR>

Posting Permissions

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