The size of my data base does not change

[SAVLO]

I have built an Access data base and at this point it's 72,252 KB, it has
been this size for about two weeks now even though I have been entering data
on a daily basis. The data base is on a server I don't know if this makes a
difference.
Can any one explain this to me?
Thanks,

 

[aaron.kempf]

databases have bloat

your database could have been bloated and then re-usign the bloat
space

hth

-Aaron

 

[Jerry Whittle]

Don't think of an Access database file as a balloon that get bigger or
smaller depending on what you put into it. It's more like a paper bag that
keeps it's shape and size no matter what you put into it. A couple of weeks
ago you did something to make the database the size it is now possibly by
running a complex query with some sorting and grouping. Then you might have
deleted some records but the size stays the same. It's like an open, half
empty paper bag. It will stay the same until you (1) do a compact and repair,
or (2) do something to cause the database to grow like add some records, add
an index, do some complex queries, create some forms and reports.

In other words, don't worry about it.

 

[John W. Vinson]

I have built an Access data base and at this point it's 72,252 KB, it has
been this size for about two weeks now even though I have been entering data
on a daily basis. The data base is on a server I don't know if this makes a
difference.
Can any one explain this to me?
Thanks,

Just one additional note to the two suggestions you've gotten: I understand
that Access allocates disk to .mdb files in 32KByte chunks. Therefore you
could add quite a lot of data (a thousand or so 30-byte records) to a database
without seeing any change at all, only to see it expand from 72,252 to 105,020
bytes when you add one tiny record.

Given that an Access database can contain up to two billion bytes... you're
not in any danger currently!

John W. Vinson [MVP]

 

[i_takeuti]

I have built an Access data base and at this point it's 72,252 KB, it has
been this size for about two weeks now even though I have been entering
data
on a daily basis. The data base is on a server I don't know if this
makes a
difference.
Can any one explain this to me?
Thanks,

 

[aaron.kempf]

Fascinating... I really never knew that

SQL Server does this in extents; which is 8kb chunks..


is it possible to control / modify this behaivor in Access?

 

[Tony Toews [MVP]]

Fascinating... I really never knew that

SQL Server does this in extents; which is 8kb chunks..


is it possible to control / modify this behaivor in Access?

Not to my knowledge.
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm