Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database not growing in File size

Status
Not open for further replies.

evergreean

Technical User
Feb 15, 2006
68
US
I have an Access 2000 database with a Cold Fusion web front end. It has 4 tables and the file size has not grown for the past 100 records that were added to the database. Most of the records added were in memo fields with alot of words sometimes up to 200 or 300 words in a couple memo fields which make up 1 record.

Please advise why it has not grown (it stays at 2170 KB or equals to around 2 MB). Is there a possible problem I should be aware of. Other than that everything is working great.
 
I'm not sure of the increments but Access increases it's file size in blocks of something like 32K. If you are adding data at a rate smaller than that, you probably won't see any change until it needs another 32K block.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top