Re: Editing Data

From: Val Mazur (group51a_at_hotmail.com)
Date: 05/26/04 

Date: Tue, 25 May 2004 21:08:23 -0400

Hi Randy,

If you need to show the data to the client, then you need to create some
form, otherwise how could you show it? What is the actual problem? Do you
need to display the data and restrict editing? If yes, then all you need to
do is to open recordset as read-only.
One more suggestion. Do you get all 6000 row to edit one value? If yes, this
is not the best idea to work with the data. Al you need to do is to select
only the data, which you really need,work with it and apply changes to the
database. 

-- 
Val Mazur
Microsoft MVP
"Randy" <randy@NoSpamForMe.com> wrote in message 
news:10b40dh1fg8rl44@corp.supernews.com...
> 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

  • Re: Company Web
    ... If we are talking about the default web page hosted by the default web site ... > Damian, can I directly edit the html file and change the link? ... >> going through ISA Web publishing so the client gets the public link on the>> fly. ...
    (microsoft.public.windows.server.sbs)
  • Re: TADOTable exception when post second time
    ... >Then I press the edit button again, edit the values in the data-aware ... The first time you post the data the preEdit client values find a match on the ... Your choices are adCriteriaKey, adCriteriaAllCols, ...
    (borland.public.delphi.database.ado)
  • Re: need some quick advice
    ... When I was in independent contrator, I made sure my contract had a clause ... maintaining any pages that the client altered. ... > something she can edit without any software. ...
    (microsoft.public.frontpage.client)
  • Re: Fix your newsreader settings!
    ... Posts are easy to edit with OE. ... How to turn of the _automatic_ addition of a signature and instead ... - Microsoft messed up when they decided to make OE both a mail client ...
    (rec.models.railroad)
  • Re: Firewall exceptionlist with GP
    ... You can do that if you edit the Group Policy from a Windows XP SP2 computer ... Open mmc and add the Group Policy snapin and browse over to the domain GPO ... > program exception list and ports for that client. ...
    (microsoft.public.windows.group_policy)