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

    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,

  2. #2
    Join Date
    Jul 2002
    Village, MD

    Re: manually update a table

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

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

    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
    Naples, FL
    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)

    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