Editing Data

From: Randy (randy_at_NoSpamForMe.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 07:05:47 -0700

Greetings,

I am trying to Edit one field of over 6000 records (the field exists for all
of them). I would like to use ADO, but right now we only use recordsets,
and I don't want to build another form to do it. My boss wants me to use a
view, which I can do but it isn't editable.

Any one know of an easy way to do my joins on 2 different tables, allow my
customers to view the records (kind of like a table view) and not build
another form?

I am using Access 2K and Sql Server 2k.

TIA

Randy

Relevant Pages

  • Problem with ADO
    ... While testing an ADO implementation, I found that I ran into trouble if I ... ADO became convinced that I had never issued an Edit or AddNew. ... Edit does not exist in ADO; the edit is implied when you try to set a field. ... Update or CancelUpdate without AddNew or Edit. ...
    (microsoft.public.vc.mfc)
  • Re: Editing Data
    ... If you need to show the data to the client, then you need to create some ... Do you get all 6000 row to edit one value? ... Val Mazur ... "Randy" wrote in message ...
    (microsoft.public.data.ado)
  • Re: Run-time error 2147217841 Query Timeout expired
    ... Depends whether he's using ADO or DAO; ... I would expect him to be using ADO. ... If you write to a field, ADO will automatically put you in Edit ... error message "Query timeout expired". ...
    (microsoft.public.vb.general.discussion)
  • Re: Multiuser Problem
    ... Instead, they have optimisitc concurrency, in which case you compare ... > How do I lock a particular record that one user has opened for editing? ... > all edit every record. ... > My Database is SQL Server with VB.NET with ADO.NET is the ...
    (microsoft.public.dotnet.languages.vb)
  • Displaying/Modifying Multiple Tables as One Table
    ... We would like to display and edit columns from the different tables in ... * ADO Dataview ... does not allow us to edit all of them. ... columns, but not the master columns, as ADO claims, that this table ...
    (microsoft.public.dotnet.framework.adonet)