Alter a SQL table

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jfrasier
    #1

    Alter a SQL table

    I used the MS Access 2000 Upsize wizard to create a Client/server
    application. After the wizard ran, the original table names had become
    the linked tables and then there were duplicates of the the tables
    named xxx_local.

    I realized later that I needed to add some fields to a table and
    couldn't do that in Access (couldn't edit the linked tables). So I used
    the Query Analyzer and created a script to add the fields to my table.
    It looked fine in Query Analyzer, but back in Access the fields were
    added to xxx_local and not xxx, the linked table. My forms and reports
    are built on xxx, not xxx_local.

    How do I do this correctly?

    Jane

    Tags: None
    • mollyf@hotmail.com
      #2
      Re: Alter a SQL table

      jfrasier wrote:
      I used the MS Access 2000 Upsize wizard to create a Client/server
      application. After the wizard ran, the original table names had become
      the linked tables and then there were duplicates of the the tables
      named xxx_local.
      >
      I realized later that I needed to add some fields to a table and
      couldn't do that in Access (couldn't edit the linked tables). So I used
      the Query Analyzer and created a script to add the fields to my table.
      It looked fine in Query Analyzer, but back in Access the fields were
      added to xxx_local and not xxx, the linked table. My forms and reports
      are built on xxx, not xxx_local.
      >
      How do I do this correctly?
      >
      Jane
      Anytime I've added fields to a linked table in Access, I've always had
      to refresh the links (using the Linked Table Manager) in order to see
      them on the Access side. I'm not sure if the fact that I seldom use
      Query Anazlyer to add fields to a table or not has anything to do with
      it (I just go into Enterprise Manager and make the changes there). Are
      you sure you're referencing the desired table in your script?

      Molly J. Fagan

        Comment

        • jfrasier
          #3
          Re: Alter a SQL table

          I re-linked the table in Access and that did the trick. Thanks.

          Jane

          mollyf@hotmail. com wrote:
          jfrasier wrote:
          I used the MS Access 2000 Upsize wizard to create a Client/server
          application. After the wizard ran, the original table names had become
          the linked tables and then there were duplicates of the the tables
          named xxx_local.

          I realized later that I needed to add some fields to a table and
          couldn't do that in Access (couldn't edit the linked tables). So I used
          the Query Analyzer and created a script to add the fields to my table.
          It looked fine in Query Analyzer, but back in Access the fields were
          added to xxx_local and not xxx, the linked table. My forms and reports
          are built on xxx, not xxx_local.

          How do I do this correctly?

          Jane
          >
          Anytime I've added fields to a linked table in Access, I've always had
          to refresh the links (using the Linked Table Manager) in order to see
          them on the Access side. I'm not sure if the fact that I seldom use
          Query Anazlyer to add fields to a table or not has anything to do with
          it (I just go into Enterprise Manager and make the changes there). Are
          you sure you're referencing the desired table in your script?
          >
          Molly J. Fagan

            Comment

            Previous template Next
            Working...