Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2003
    Posts
    29

    Unanswered: manually update a table

    i have 2 tables in an sql db. table1 has 2400 records and table2 has 1400 records. if i open the table and select all rows in table2 and try to manually edit the contents of a field i receive the following error:

    communication link failure.

    if i open the table and select top 1000 i can manually edit any value with out any problem.

    if i open table1 and select all the rows i can edit any value i want with out any issues.

    can it be that the size of the table prevents me from editing when i select all the rows?

    extra info:
    table1 has more records and more fields but the fields in table2 are larger (navchar 50 compared to navchar20)

    Thank You,
    Thomas

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: manually update a table

    Do you have a primary or unique key on your tables?

  3. #3
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: manually update a table

    Try to use the OLE DB provider for SQL Server instead an ODBC driver, and see whether you problem persists.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  4. #4
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    Are you doing this in EM? If so, it is highly reccomended you do not edit data this way as it creates a big overhead with locks. Writing appropriate update statements would be better. (again, if you are doing it from EM)

    HTH
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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