Record Set not updatable

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
 
M

Martin Walke

Hi Joe,

How did you connect the sql tables to access? If you linked the tables and
used ODBC, the system will ask for "Unique Record Identifier" - an index
basically. I think this is caused if the index defined for accessing the SQL
table hasn't been set properly and results in an ambiguous record selection
when updating.

HTH
Martin
 
J

Joe Black

Hi Martin,

I created the database using SQL Server developer edition, then used
access to connect to the database via an ODBC connection, the tables
were there when I opened it and I wasn't asked for a "Unique Record
Identifier". I fairly new to using access for this sort of thing so if
you could advise me further I would appreciate it.

Many thanks

Joe
 
J

Joe Black

Hi Martin,

Thank you for your post, I didn't define a primary key in the table :-(

Thanks again

Joe
 
M

Martin Walke

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
 
Top