Deleting tables from remote databases

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

Paul Fenton

We have a FE/BE application and every hour, we want to upload some of
the tables from the BE file to a website so clients will have
up-to-date information on their surveys. Thus far, we've been
uploading the entire BE file in the evening after we close.

I created database A which has the relevent tables. First I delete
those tables and then, using the TransferDatabase method, I import the
current tables from the Master BE file.

Next, with Make Table queries, I create the tables in datase B and
compact it. Database B then gets uploaded every hour and it stays
small.

The problem is that database A (always open) grows every time I import
a new set of tables from the BE database. Same thing happens in
database B, but as it's always closed, I can compact it in a macro.

Since I can't compact the open database A, I was thinking a better way
would be to have a module in the BE file that deletes the tables in
database B and then just exports the tables I need, eliminating the
need for database A to be open all the time or to even exist.

How do I delete tables in database B from the master BE file?

Or, is there a better way to do this altogether?



Paul Fenton
(e-mail address removed)
 
Create a temporary database in which you create the temporary tables and
link to them. When done, delete the entire temporary database. There's no
bloat in your database due to this process. There's an example and
information on this approach at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
 
Back
Top