doing a update

**salad** · Apr 23 '06, 05:55 PM

Re: doing a update

Roy wrote:
[color=blue]
> Hi Access gurus,
> I have a A2K application.The data in the database is updated daily by a
> excel download.I have a master n related tables keyed in by a OrderID.I
> have a problem in updating data.If it is a one to one update,i face no
> problem as I update every fields.But let's say if there is a master
> record with ID and three corresponding related entries for this on day
> 1.But on the next day,there was a change on related records 2 & 3 but
> not on the first.[/color]

Where is the change coming from? Excel or Access? Does the data in
Access change, or does the data change in Excel, or both?

Then how will I raise a flag so that updates are done[color=blue]
> only on the second and third but not on first?[/color]

Does your Excel download download all records or just those that have
been updated? Can it be modified to include only those records that
have been updated?

Let me explain further:I[color=blue]
> have a stopUpdate button on every table including the Master.When no
> updates are needed,I can check this button on the Master,thus
> preventing updates on related tables.Or if it is just a one record,i
> can update alll fields without any problems.But my main problem is
> ,when I need to update selected records on the related tables ,I cannot
> have the button checked in the master.Or should I have stopupdate on
> each related record?Hope I have been clear.Thanks in advance.[/color]

Is there anything you can do by linking the Excel data within Access.
If you have A2003 I don't think you can update from Access but you can
update from Excel. If you have another version (less that AXP I think)
you can update from both sides. It's something you may want to check
out in Google Groups...http://groups.google.com/advanced_search?hl=en
Enter
*access*
in the groups box of the search.
[color=blue]
>
> Roy
>[/color]

**Roy** · Apr 24 '06, 02:15 AM

Re: doing a update

Hi ,
Thanks for the reply.The Download is from Excel and includes all
records and not just changed data.I cannot do the linking of excel
sheet direct because of the application needs.

salad wrote:[color=blue]
> Roy wrote:
>[color=green]
> > Hi Access gurus,
> > I have a A2K application.The data in the database is updated daily by a
> > excel download.I have a master n related tables keyed in by a OrderID.I
> > have a problem in updating data.If it is a one to one update,i face no
> > problem as I update every fields.But let's say if there is a master
> > record with ID and three corresponding related entries for this on day
> > 1.But on the next day,there was a change on related records 2 & 3 but
> > not on the first.[/color]
>
> Where is the change coming from? Excel or Access? Does the data in
> Access change, or does the data change in Excel, or both?
>
> Then how will I raise a flag so that updates are done[color=green]
> > only on the second and third but not on first?[/color]
>
> Does your Excel download download all records or just those that have
> been updated? Can it be modified to include only those records that
> have been updated?
>
> Let me explain further:I[color=green]
> > have a stopUpdate button on every table including the Master.When no
> > updates are needed,I can check this button on the Master,thus
> > preventing updates on related tables.Or if it is just a one record,i
> > can update alll fields without any problems.But my main problem is
> > ,when I need to update selected records on the related tables ,I cannot
> > have the button checked in the master.Or should I have stopupdate on
> > each related record?Hope I have been clear.Thanks in advance.[/color]
>
> Is there anything you can do by linking the Excel data within Access.
> If you have A2003 I don't think you can update from Access but you can
> update from Excel. If you have another version (less that AXP I think)
> you can update from both sides. It's something you may want to check
> out in Google Groups...http://groups.google.com/advanced_search?hl=en
> Enter
> *access*
> in the groups box of the search.
>[color=green]
> >
> > Roy
> >[/color][/color]

**salad** · Apr 24 '06, 04:15 PM

Re: doing a update

Roy wrote:[color=blue]
> Hi ,
> Thanks for the reply.The Download is from Excel and includes all
> records and not just changed data.I cannot do the linking of excel
> sheet direct because of the application needs.[/color]

I guess I'm still confused. Does the download from Excel simply
overwrite the Access data? How do you update existing records if it
doesn't? Let's say that you change recs 1&3, not 2. Does it matter if
you update all 3 or do you also change data in Access and only update
1/3 because those changes come from Excel? If data changes in Excel on
detail one-2-many recs, can you not put a flag to note a change in
Excel...or Access tables? Do you change data in both Excel and Access?
You know the specs, but it's hard to grasp the idea of what you are
doing from what you have written.
[color=blue]
> salad wrote:
>[color=green]
>>Roy wrote:
>>
>>[color=darkred]
>>>Hi Access gurus,
>>>I have a A2K application.The data in the database is updated daily by a
>>>excel download.I have a master n related tables keyed in by a OrderID.I
>>>have a problem in updating data.If it is a one to one update,i face no
>>>problem as I update every fields.But let's say if there is a master
>>>record with ID and three corresponding related entries for this on day
>>>1.But on the next day,there was a change on related records 2 & 3 but
>>>not on the first.[/color]
>>
>>Where is the change coming from? Excel or Access? Does the data in
>>Access change, or does the data change in Excel, or both?
>>
>>Then how will I raise a flag so that updates are done
>>[color=darkred]
>>>only on the second and third but not on first?[/color]
>>
>>Does your Excel download download all records or just those that have
>>been updated? Can it be modified to include only those records that
>>have been updated?
>>
>>Let me explain further:I
>>[color=darkred]
>>>have a stopUpdate button on every table including the Master.When no
>>>updates are needed,I can check this button on the Master,thus
>>>preventing updates on related tables.Or if it is just a one record,i
>>>can update alll fields without any problems.But my main problem is
>>>,when I need to update selected records on the related tables ,I cannot
>>>have the button checked in the master.Or should I have stopupdate on
>>>each related record?Hope I have been clear.Thanks in advance.[/color]
>>
>>Is there anything you can do by linking the Excel data within Access.
>>If you have A2003 I don't think you can update from Access but you can
>>update from Excel. If you have another version (less that AXP I think)
>>you can update from both sides. It's something you may want to check
>>out in Google Groups...http://groups.google.com/advanced_search?hl=en
>>Enter
>> *access*
>>in the groups box of the search.
>>
>>[color=darkred]
>>>Roy
>>>[/color][/color]
>
>[/color]

doing a update

doing a update

Comment

Comment

Comment