Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Unanswered: basic update query question (access 2007)


    My table has 300 fields or columns. I have two tables (same fields) and I need to do a single update query that update all the fields on a primary key. I think this can be automatically using Query Designer. Right?

  2. #2
    Join Date
    Jun 2007
    Maitland NSW,Australia
    I have not used 2007, but I assume you can update providing the primary key is the same name and data type etc. But updating 300 fields may cause problems performance wise. Make sure you have a copy of both tables before you update in case there are problems.

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    I've never had 300 columns in one table!

    Sounds like the answer is YES, but it kinda depends on what you mean by "automatically".
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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