Database size - problem

Hi,

I really need help and or an explanation. I am working on a database to
complete orders with confirmation, bills, .... everything is working pretty
fine and in the end the size of the database was about 12 MB big.
Now I added 3 tables, 5 more forms and 5 reports. Those are just used to
type data in, save it and to print it out. The forms have a good amount of
text and fields, but the about of data saved is small.
My problems is that the size of the database jumped from 12 MB to 50 MB and
even if I go and export just that part in a new database it gets 30 MB right
away just by saving. Can that be possible? The new forms and reports are not
much different as the ones that are already there and the way they work is
the same, too.

I really appreciate any adive, tip, hint.

Thanks
Nicole

re: Database size - problem

"nicole" <nbissell2004@yahoo.com.nospam> wrote in message
news:yusQd.10532$Nw6.2650@fe06.lga...[color=blue]
> Hi,
>
> I really need help and or an explanation. I am working on a database to
> complete orders with confirmation, bills, .... everything is working
> pretty fine and in the end the size of the database was about 12 MB big.
> Now I added 3 tables, 5 more forms and 5 reports. Those are just used to
> type data in, save it and to print it out. The forms have a good amount of
> text and fields, but the about of data saved is small.
> My problems is that the size of the database jumped from 12 MB to 50 MB
> and even if I go and export just that part in a new database it gets 30 MB
> right away just by saving. Can that be possible? The new forms and reports
> are not much different as the ones that are already there and the way they
> work is the same, too.
>
> I really appreciate any adive, tip, hint.[/color]

Nicole,

If you are saving any graphics in the file that would explain it. What kind
of background do you have for the forms? Any pictures on the reports?

What is the problem with a 50M database? That really isn't so big now-days.
If you need to move the file via email then try using winzip to compress the
file for emailing and the file can then be uncompressed by the recipient.

Mike

re: Database size - problem

Thanks a lot. I did not consider the new logo saved in the new reports and
forms. After deleting it, the size decreased about 30 MB.


"Mike Turco" <miketurco@yahoo-no-spam-4-me.com> wrote in message
news:DIsQd.79258$bu.61467@fed1read06...[color=blue]
>
> "nicole" <nbissell2004@yahoo.com.nospam> wrote in message
> news:yusQd.10532$Nw6.2650@fe06.lga...[color=green]
>> Hi,
>>
>> I really need help and or an explanation. I am working on a database to
>> complete orders with confirmation, bills, .... everything is working
>> pretty fine and in the end the size of the database was about 12 MB big.
>> Now I added 3 tables, 5 more forms and 5 reports. Those are just used to
>> type data in, save it and to print it out. The forms have a good amount
>> of text and fields, but the about of data saved is small.
>> My problems is that the size of the database jumped from 12 MB to 50 MB
>> and even if I go and export just that part in a new database it gets 30
>> MB right away just by saving. Can that be possible? The new forms and
>> reports are not much different as the ones that are already there and the
>> way they work is the same, too.
>>
>> I really appreciate any adive, tip, hint.[/color]
>
> Nicole,
>
> If you are saving any graphics in the file that would explain it. What
> kind of background do you have for the forms? Any pictures on the reports?
>
> What is the problem with a 50M database? That really isn't so big
> now-days. If you need to move the file via email then try using winzip to
> compress the file for emailing and the file can then be uncompressed by
> the recipient.
>
> Mike
>
>
>[/color]

re: Database size - problem

"nicole" <nbissell2004@yahoo.com.nospam> wrote:
[color=blue]
>Thanks a lot. I did not consider the new logo saved in the new reports and
>forms. After deleting it, the size decreased about 30 MB.[/color]

1) Put the logo in one form and one report and use those as subreports.

2) Leave it on the server and load it in in the OnOpen Event of the form or report.

Tony
--
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