Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Need help using ACCESS 2000


    I have a Link Table from ACCESS 2000 to Sql Server 2000, I can view the entire table in ACCESS 2000 , but it is not allowing me to update or add new records to it,

    If any one knows about this, Kindly let me know


  2. #2
    Join Date
    Feb 2004
    Access cannot update records on any ODBC linked table if it does not have a unique index on.

    Open the table in design view and look for a key.

    Unlink the table and relink it. If Access prompts you for a unique key it means that it cannot see the index (if any) on the table. Select the field(s) required to have a unique index.

    If this is not it then recheck to see if you have update, insert permissions on the server.

Posting Permissions

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