|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
September 30th, 2003, 10:47 AM
|
|||
|
|||
Size problems after Table Deletion
I am relatively new but here is a problem:
Background: I routinely download MainFrame VSAM files into Text format and import them into Access. Each file contains 100,000+ records, with record length of 700 bytes. Therefore each file is approximately 75-85 megs and growing. This file grows by about 1000 records a week and I download it each week. Needless to say the database is large (approximately 100 megs). Problem: After three or four weeks I delete the the previous tables, but the database size does not decrease. My latest DB was about 900 megs before I was forced to delete and start over. Question: It seems like Access isn't releasing the data after I delete the tables. Is there any way to refresh the DB or clear the associated memory of those tables?
|
|
#2
October 1st, 2003, 01:32 AM
|
||||
|
||||
|
Compact your database. Then re-check the size.
Look up compacting in your Access Help, its very important. Regards, 
__________________
Regards, John A
|
|
#3
October 1st, 2003, 08:57 AM
|
|||
|
|||
|
Thanks!!
That made a huge difference!
I thought compacting was like Zipping. I really appreciate the help!.
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Size problems after Table Deletion |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
