database file size

[Carlos Paiva]

Try to compact the database, and see if it gets smaller!
probably, you write & delete information several times, and database
gets fragmented.
I hope this helps you.

Carlos Paiva


"panaitescu" <calimero69@hotmail.com> escreveu na mensagem
news:3cbec7d3$1@10.1.10.29...
>
> hi,
> I am tring to do a simple database using the visual basic's visual data
manager.
> For texts I use fields of type "string" and for pictures(bitmaps) I use a
> field of type "binary". After testing the program I noticed that the
database
> file was disproportionate large(about 12Mb) compared with the actual size
> of data that I enterd(just some text and about 30 bitmaps - average size
> 60kb). Is this normal? Are there better solutions that will use more
efficiently
> the HD space?

[panaitescu]

hi,
I am tring to do a simple database using the visual basic's visual data manager.
For texts I use fields of type "string" and for pictures(bitmaps) I use a
field of type "binary". After testing the program I noticed that the database
file was disproportionate large(about 12Mb) compared with the actual size
of data that I enterd(just some text and about 30 bitmaps - average size
60kb). Is this normal? Are there better solutions that will use more efficiently
the HD space?

[panaitescu]

"Carlos Paiva" <c_paiva@sapo.pt> wrote:
> Try to compact the database, and see if it gets smaller!
>probably, you write & delete information several times, and database
>gets fragmented.
> I hope this helps you.
>
> Carlos Paiva
>
>
>"panaitescu" <calimero69@hotmail.com> escreveu na mensagem
>news:3cbec7d3$1@10.1.10.29...
>>
>> hi,
>> I am tring to do a simple database using the visual basic's visual data
>manager.
>> For texts I use fields of type "string" and for pictures(bitmaps) I use
a
>> field of type "binary". After testing the program I noticed that the
>database
>> file was disproportionate large(about 12Mb) compared with the actual size
>> of data that I enterd(just some text and about 30 bitmaps - average size
>> 60kb). Is this normal? Are there better solutions that will use more
>efficiently
>> the HD space?
>
>
yes, I intend to write & delete in my database frequently. What method/function
to use to compact the database?

[Carlos Paiva]

It depends on which syatem you use to access the data base.
If you use DAO, then execute the command DBEngine.CompactDatabase
If you use ADO, you should Reference JRO and use it to compact Database
(Jet Only)

Regards,
Carlos Paiva

"panaitescu" <calimero69@hotmail.com> escreveu na mensagem
news:3cbefbed$1@10.1.10.29...
>
> "Carlos Paiva" <c_paiva@sapo.pt> wrote:
> > Try to compact the database, and see if it gets smaller!
> >probably, you write & delete information several times, and database
> >gets fragmented.
> > I hope this helps you.
> >
> > Carlos Paiva
> >
> >
> >"panaitescu" <calimero69@hotmail.com> escreveu na mensagem
> >news:3cbec7d3$1@10.1.10.29...
> >>
> >> hi,
> >> I am tring to do a simple database using the visual basic's visual data
> >manager.
> >> For texts I use fields of type "string" and for pictures(bitmaps) I use
> a
> >> field of type "binary". After testing the program I noticed that the
> >database
> >> file was disproportionate large(about 12Mb) compared with the actual
size
> >> of data that I enterd(just some text and about 30 bitmaps - average
size
> >> 60kb). Is this normal? Are there better solutions that will use more
> >efficiently
> >> the HD space?
> >
> >
> yes, I intend to write & delete in my database frequently. What
method/function
> to use to compact the database?