[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
This Recordset Is Not Updatable

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

This Recordset Is Not Updatable.


Applies to: Microsoft Access 2000 project using an existing SQL Server 2005 SP2 database.

 

Problem Description.
 

When you try to update, delete or insert a record on a table in an Access Project, Microsoft Access beeps, then you receive the following error in the status bar:

This recordset is not updatable.






 

Cause.


The table you are trying to update does not have primary key or a unique index.

 

Solution.


Create a primary key or a unique index on the table.


 


 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.