Record Set not updatable

  • Thread starter Thread starter Joe Black
  • Start date Start date
J

Joe Black

Hi all,

Using SQL Server 2000
MS Access 2003

Just wondering if someone could shed some light on this:

I have created a database in SQL Server 2000 with 3 tables in it, I have
created the table in exactly the same manner in SQL Server Enteprise
manager.

In Access I created and Access project that connected to the above
database, the first 2 tables I created can be viewed and edited fine in
Access but the last one I created will allow viewing only. I don't think
its a SQL Server problem because I can view/edit the data in the table
fine, in Access however I get "This recordset is not updatable" when I
try to edit the data.

Does anyone what causes this and how to rectify it so I can edit the
data within the table?

Thanks

Joe
 
It's another example of where the error message is correct in one aspect but
not quite enough info in another.

Glad I could help

Martin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Best way to deploy Access read-only database that is linked to SQL tables 6
Record Not updatable question 1
Data Access Pages Data Source 2
MS Access 2010 Web Application with SQL server 0
Access stripping decimal places in query 1
Access 2003 and SQL2000 Table Problems 1
Linked SQL Tables don't report Cascading Updates and Deletes 2

Back
Top