G
Guest
I have two access databases A & B. I want to update some tables from B to A
on periodic basis.
on periodic basis.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
Open one of the databases. Link to the tables in the other. Create queries
to do the updates from dbB's tables to dbA's tables.
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
to do the updates from dbB's tables to dbA's tables.
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
G
Guest
thank you for your response.
can you please explain with an example.
can you please explain with an example.
J
Jeff Boyce
Save a copy of dbA and dbB ... your "update" will modify data and you need a
fall-back copy.
Open database A. Use <File | Get External ... | Link ...> to navigate to
database B. Select the tables from dbB that you want to use to update the
corresponding tables in dbA.
Read up on "Update queries".
Create a new query. Add a table from databaseA. Add the corresponding
table from databaseB. Join the two tables on their common ID field.
Select a field from the dbA table that you want updated. Click on the
toolbar button that lets you change the query type to "update". There'll be
a new row in the grid. In this row, add the field from the dbB table you
want to use to update it ... you'll probably need to enter the full path
(e.g., [tableB].[FieldName]). Again, read up on "update queries" for more
examples.
Run the query. Did it update the field value in the dbA table?
And once more, update queries change data. Before doing one, make backup
copies and read up in Access HELP and on-line to learn more about how to do
it.
Good luck!
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
fall-back copy.
Open database A. Use <File | Get External ... | Link ...> to navigate to
database B. Select the tables from dbB that you want to use to update the
corresponding tables in dbA.
Read up on "Update queries".
Create a new query. Add a table from databaseA. Add the corresponding
table from databaseB. Join the two tables on their common ID field.
Select a field from the dbA table that you want updated. Click on the
toolbar button that lets you change the query type to "update". There'll be
a new row in the grid. In this row, add the field from the dbB table you
want to use to update it ... you'll probably need to enter the full path
(e.g., [tableB].[FieldName]). Again, read up on "update queries" for more
examples.
Run the query. Did it update the field value in the dbA table?
And once more, update queries change data. Before doing one, make backup
copies and read up in Access HELP and on-line to learn more about how to do
it.
Good luck!
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
G
Guest
Thank you for the GREAT advice....... Very Best Regards.
Jeff Boyce said:Save a copy of dbA and dbB ... your "update" will modify data and you need a
fall-back copy.
Open database A. Use <File | Get External ... | Link ...> to navigate to
database B. Select the tables from dbB that you want to use to update the
corresponding tables in dbA.
Read up on "Update queries".
Create a new query. Add a table from databaseA. Add the corresponding
table from databaseB. Join the two tables on their common ID field.
Select a field from the dbA table that you want updated. Click on the
toolbar button that lets you change the query type to "update". There'll be
a new row in the grid. In this row, add the field from the dbB table you
want to use to update it ... you'll probably need to enter the full path
(e.g., [tableB].[FieldName]). Again, read up on "update queries" for more
examples.
Run the query. Did it update the field value in the dbA table?
And once more, update queries change data. Before doing one, make backup
copies and read up in Access HELP and on-line to learn more about how to do
it.
Good luck!
--
Regards
Jeff Boyce
www.InformationFutures.net
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
Niaz Ahmad said:thank you for your response.
can you please explain with an example.