Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 27th, 2006, 10:44 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default Pairing down MDB size (?)

I am currently working on an mdb and am concerned regarding it's size. It's up to 15.9MB and am about half done. Included in this so far are 24 forms, 8 reports and a single module. I have less than a dozen records at the moment. And only about 10 jpegs (the Company Logo-required by my employer). I'm concerned by the time I'm complete it will be a real fat, slow beast!

This seems rather large for what it contains. I've compiled, compacted and repaired. The machine I'm working on has A2003 on it but the mdb is in A2K. I have no extra add-ins (other than DAO library- which I need (would it add overhead anyway?). And I have just the usual code for validation and record processing.

1) COuld someone tell me, doesn't this seem a bit large?
2) Is there a way to tell the size of the individual objects? (I've already tried the "Documenter"- no luck. "Killing" a copy of one form and then compacting showed a 100KB size difference.)

Thanks,
Loralee


 
Old August 28th, 2006, 12:11 AM
Authorized User
 
Join Date: Apr 2006
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I believe you can create an Mde version that should be a bit smaller and a bit faster.

Also if it ends up too big you could create a couple of databases, one that contains your data and quesries, the other that contains the forms.

 
Old August 28th, 2006, 12:12 AM
Authorized User
 
Join Date: Apr 2006
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

btw, 15.9 mb doesnt sound all that big.

 
Old August 28th, 2006, 06:32 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   The reason the mdb file is probably so big already is that you are still designing it. During design, it can get pretty large, even with no data.

   In Access, go to Tools > Options, and then select the General Tab. In the lower left, select Compact on Close. This is an important option during design. That should start to reduce the size of the file.

Does this help?



mmcdonal
 
Old August 28th, 2006, 10:05 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Another possible cause of large dB size other than not compacting it is your table design. Here are some things that could make the dB bigger.

1) Are your tables normalized? Are you repeating data in tables instead of storing them once only?

2) Are you storing calculated values? In a word, DON'T!

3) Are you storing photographs or clip-art? In a word, DON'T! Store the path and file name to them and link to them, but don't actually store the actual picture.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old August 28th, 2006, 10:08 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You can use the images as form backgrounds, for example, by pasting them in the forms. I find that doesn't add much to file size. However, if you store them in tables as OLE images, the file size will grow exponentially.


mmcdonal
 
Old August 29th, 2006, 07:29 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks, Guys.

It's normalized Most of the tables are look ups (not using the wizard) and referenced via SQLs. The only images are small jpegs (the company logo). It just seems big at this stage for so little test data.

Thanks






Similar Threads
Thread Thread Starter Forum Replies Last Post
import data from mdb to another mdb mat41 Classic ASP Professional 3 March 9th, 2007 07:01 AM
Size of text box depending on size of another box AstridVM BOOK: Access 2003 VBA Programmer's Reference 0 March 7th, 2007 06:24 AM
grocertogo.mdb Webdealer Wrox Book Feedback 1 June 8th, 2006 08:04 AM
Icecream.mdb zoomer67 BOOK: Beginning Access VBA 0 June 18th, 2005 08:02 AM
MDB in HTML Add_R Access 0 January 30th, 2005 09:26 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.