Is there any way to have one Access 2K database send information to tables in another A2K database using VBA? Both are split back end/front end, with all back ends sitting on the same server.
I would like to be able to do this without necessarily linking the tables, as there may be multiple databases involved. Any ideas for the most efficient way to accomplish this? Curious, how much memory do linked tables add to a front end delivered as an MDE? Still in the early stages, so feedback is welcome.
This is not for reports and such; for that I can do the linking easily.