By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,528 Members | 1,304 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,528 IT Pros & Developers. It's quick & easy.

Database size - problem

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"nicole" <nb**********@yahoo.com.nospam> wrote in message
news:yu******************@fe06.lga...
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.


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

Nov 13 '05 #2

P: n/a
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" <mi*******@yahoo-no-spam-4-me.com> wrote in message
news:DIsQd.79258$bu.61467@fed1read06...

"nicole" <nb**********@yahoo.com.nospam> wrote in message
news:yu******************@fe06.lga...
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.


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

Nov 13 '05 #3

P: n/a
"nicole" <nb**********@yahoo.com.nospam> wrote:
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.


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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.