Why isn't table updatable????

[Richard Hollingsworth]

Hello:

I've just converted my Access 2K db to SQL Server 2K and the conversion went
smoothly. I created users, roles, views and forms and gave the users
permissions to use them. I "THINK" I have done everything, but......you
cannto update the form, view, or table. I get "Recordset Not Updatabale"
when I modify a field in either.

Assuming I set the permissions correctly on the db, table, view, and users
correctly, is there something else I need to do to make the table and view
updatable?

My front end is Access 2K.

Thanks for any advise.....
Richard H

[Erland Sommarskog]

Re: Why isn't table updatable????

Richard Hollingsworth (william.r.holl ingsworth@boein g.com) writes:[color=blue]
> I've just converted my Access 2K db to SQL Server 2K and the conversion
> went smoothly. I created users, roles, views and forms and gave the
> users permissions to use them. I "THINK" I have done everything,
> but......you cannto update the form, view, or table. I get "Recordset
> Not Updatabale" when I modify a field in either.
>
> Assuming I set the permissions correctly on the db, table, view, and users
> correctly, is there something else I need to do to make the table and view
> updatable?[/color]

Without any information about the view and the table, it is difficult
to say, but ADO must be able to uniquely identify the rows in the
recordset. In clear text this means that the table must have a primary
key, and this key must be exposed in the query and in the result set.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp