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

Passing values between Databases

P: n/a
Hi all. I am trying to build a database that will manage all of the
processes that I have running in auxillary .mdb's. I can use the
"Parent" database to open the "Child" databases and run the code to
update the local tables etc. using Macros & RunCode(). But I cannot
figure out how to pass a string back to the "Parent" database when the
process is done so that it can update a table there apprising me of
the status(e.g. "Successful: " & Now() or "Failed:" & Err.Number). I
primarily use DAO to accomplish my actions. Can anyone tell me what
is the appropriate way to do this. Thanks for any help.

Paul
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can make this all simpler by creating linked tables in your Parent database
that link to the tables in the auxiliary databases. You then build your forms
around the linked tables. Any data you then enter in a form will go to the table
in the auxiliary database that the linked table is linked to.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Paul Shea" <pa*******@troutmansanders.com> wrote in message
news:e6**************************@posting.google.c om...
Hi all. I am trying to build a database that will manage all of the
processes that I have running in auxillary .mdb's. I can use the
"Parent" database to open the "Child" databases and run the code to
update the local tables etc. using Macros & RunCode(). But I cannot
figure out how to pass a string back to the "Parent" database when the
process is done so that it can update a table there apprising me of
the status(e.g. "Successful: " & Now() or "Failed:" & Err.Number). I
primarily use DAO to accomplish my actions. Can anyone tell me what
is the appropriate way to do this. Thanks for any help.

Paul

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.