Updating Data in A View

message from Randy on 24 May 2004
I qork on an Access 2K front end to a SQL Server 2k database. I have a
customer that has over 6000 records in a series of tables that he wants to
update one field (which exists for all rows) but wants to do it easier then
the form which we already have for it.

Any ideas? My boss wants to use a view, but I can't get it to come out
editable. I would prefer to use ADO, but am unsure how to do this. We
currently use PassThru Queries to the SQL Server for most data translation,
and we have recently transitioned into ADO, but through the use of
recordsets. Not sure how I would use a recordset to do this, I am trying to
not build yet another form.

Any thoughts or ideas would be great.

Thanks,

Randy
 

Archived message: Updating Data in A View (Microsoft Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.