Copying Tables from one db to another

  • Thread starter Thread starter Paul Fenton
  • Start date Start date
P

Paul Fenton

I have 3 databases, A, B, C where A is the BE db for an application.
C is a db that is uploaded every hour to a web server. B is the db
that does the work of getting certain tables from A and updating them
in B by using a form with a timer.

A and B are always open, C is always closed. Since C is closed, I can
compact it after every update to kill the bloat, but I can't do that
with B, since it has to stay open for the timer to fire every hour.

Initially, I was bringing the tables into B, from A, and then sending
them to C. But then B became horribly bloated. Other than that, it
was working swimmingly.

Is there a way I can use B (with the timer) to get table from A to C
without storing them temporarily in B?


Paul Fenton
(e-mail address removed)
 
I'm not sure why you need to copy the table(s) from C at all.
Why not just link them to A?

- Turtle
 
Maybe I didn't explain it very well.

Database "C" is the .mdb file that gets uploaded to the web server
which is located in another city. If the tables in "C" are only
linked to database "A", then if it's uploaded to another computer,
there would be no data without the presence of db "A".

Is that not correct, or am I missing something?


Paul Fenton
 
Turtle, I read your reply again and the lightbulb went off! SO
SIMPLE! Why didn't I think of that before? Yes, linking the tables
in B to the originals in A and then running queries in B to re-create
them in C did the trick.

Thank you so much!


Paul Fenton
 
Is there a way I can use B (with the timer) to get table from A to C
without storing them temporarily in B?
Click to expand...

Should be; use the OpenDatabase method to open a database object on A,
and another on C, and then use the TransferDatabase method to move the
table. Or, use TransferDatabase to *link* to the table in A and also
in C and run an Append query from one linked table to the other
(though this may induce some bloat, I haven't tried it).
 
Thank you John. I came up with a way to link tables in A to database
B and then Make Tables in C. Works quite well.

Paul Fenton
 
Back
Top