I want to allow some of my users to update fields in an SQL Server 2000 Table using an ODBC link through MS-Access 2000. I have assigned the appropriate permissions in SQL server, but when I try to edit the table in access, it still says "Record Set Not Updateable". Have I forgotten something?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating SQL Server Table Using Access
- Thread starter scotward
- Start date
RobertT687
Programmer
Make sure the linked table has either a unique index or a primary key. Access won't allow updates to tables that lack these items.
- Status
Similar threads
- Locked
- Question
