Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    We have an SQL database connected to Access via an ODBC link. When viewing the design of a table in SQL Server 2005 Management Studio or Access 2007, the fields are listed in the order in which they were created. Presumably the actual order of the fields is not important to applications that use the database, and they can be presented in a different order using queries, forms and reports. However, is it possible to change the actual order in which fields are listed when viewing the design of a table, for convenience and clarity, without recreating a new table and transferring the data into it?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    In Access you can drag & drop the fields in Design view. I don't know about doing this in a linked DB.

    RG
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    You can rearrange fields in SQL Server 2005 and 2008 by clicking on a field (called column in SQL Server) and dragging it up or down. However you are changing the design when you do that, as you have to save it for it to be permanent. And after you do that in SQL Server, then will need to relink the table so that Access sees them in the new order. As an alternative, you can create a view in SQL Server (much like a query in Access), and then link to the view from Access and that lets you arrange the fields in any order that you wish. Note however that the order of the fields has no significance in either Access or SQL Server - the only reason for changing it might be to provide clearer documentation.
    Wendell

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts
    Thanks for your replies.

Posting Permissions

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