K
karlmcauley
Hello,
This is a request for further information and if possible any help!!
I have separate mdbs that each hold different sets of data and are
separated for particular reasons. However, when trying to update these
mdbs (from a mainframe dataset) i have to do it one at a time and it
can get time consuming.
What i would like is one mdb (a holding mdb) which stores all
information. Then i can go into it and fire off commands/macros/vba
(whatever is best) to update/append the tables in each of the various
separate mdbs. Is this possible? I realise that you can link the tables
held in the separate mdbs to the tables in the holding mdb and this
will update/append when changes are made - but is this the best way? is
there code to do it? or can i just fire off a macro to update/append
each table in turn?
Any guidance on the process would be greatly appreciated.
Thx in advance
This is a request for further information and if possible any help!!
I have separate mdbs that each hold different sets of data and are
separated for particular reasons. However, when trying to update these
mdbs (from a mainframe dataset) i have to do it one at a time and it
can get time consuming.
What i would like is one mdb (a holding mdb) which stores all
information. Then i can go into it and fire off commands/macros/vba
(whatever is best) to update/append the tables in each of the various
separate mdbs. Is this possible? I realise that you can link the tables
held in the separate mdbs to the tables in the holding mdb and this
will update/append when changes are made - but is this the best way? is
there code to do it? or can i just fire off a macro to update/append
each table in turn?
Any guidance on the process would be greatly appreciated.
Thx in advance