Table Refresh Storing backup?

  • Thread starter Thread starter mark
  • Start date Start date
M

mark

Hi.

I have a table that I'm refreshing from an ADO recordset which comes from an
Oracle database.

I want a total refresh on the table... doesn't matter to me whether the
records are deleted, or the table dropped and recreated (though I've read
it's usually bad form to drop and recreate a table that just needs it's
records replaced).

But, the question is... there seems to be some kind of backup going on in
Access. I've these two things (seperately):

CurrentDb.Execute "drop table tblLoadCap"
CurrentDb.Execute "delete from tblLoadCap"

In each case, every time that I run the process, the database size grows by
about 20MB, whereas 20MB is the approximate size of what a single set of the
data should be.

Can someone tell me what command I should execute so that my database does
not just keep growing and growing in size, every time that the table is
refreshed?

Thanks,
Mark
 
so it turns out that the database needs to be compacted after doing
operations like that. guess that make sense, though I'm too inexperienced
with Access to really understand fully why.

but anyway, the database still seems surprisingly large. The main object in
the database is a table with 31 text fields. Right now, the text fields are
255 characters in length, though I plan to shorten them.

anyway, this table has about 570k records, and the database is almost
289MB... that's nearly 500k per record!?

still working on that one.
 
Back
Top