By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,077 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

doing a update

P: n/a
Roy
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.

Roy

Apr 23 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.

Roy

Apr 23 '06 #2

P: n/a
Roy
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.

Roy


Apr 24 '06 #3

P: n/a
Roy wrote:
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 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.

Roy


Apr 24 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.