Hello,
I have a view in Sql Server 2000 in which I can edit data and enter data.But the same view doesnt allow me to enter data in access project.Any work around please..
Thanks
If there are multipule tables in the view you must indicate which table is to be updated. There is a place under the Data Tab to indicate the table. Also, there must be a unique index on the table or possibly a timestamp field would fill the role.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.