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.Then how will I raise a flag so that updates are done
only on the second and third but not on first?Let me explain further:I
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.

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.
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 only on the second and third but not on first?
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 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.
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.

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:

Roy wrote:

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.

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

only on the second and third but not on first?

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

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.

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.

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.
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.
salad wrote:

Roy wrote:

Hi Access gurus,I have a A2K application.The data in the database is updated daily by aexcel download.I have a master n related tables keyed in by a OrderID.Ihave a problem in updating data.If it is a one to one update,i face noproblem as I update every fields.But let's say if there is a masterrecord with ID and three corresponding related entries for this on day1.But on the next day,there was a change on related records 2 & 3 butnot on the first.

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

Then how will I raise a flag so that updates are done

only on the second and third but not on first?

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

Let me explain further:I

have a stopUpdate button on every table including the Master.When noupdates are needed,I can check this button on the Master,thuspreventing updates on related tables.Or if it is just a one record,ican update alll fields without any problems.But my main problem is,when I need to update selected records on the related tables ,I cannothave the button checked in the master.Or should I have stopupdate oneach related record?Hope I have been clear.Thanks in advance.

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 canupdate 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 checkout in Google Groups...http://groups.google.com/advanced_search?hl=enEnter *access*in the groups box of the search.