98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » File size
File size
Resolved · Low Priority · Version 2003
Thu 10 Sep 2009, 11:06Delegate Vishal said...
Vishal has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Advanced course
File size
Thank you for your help with my previous question on how to introduce a forex table to an existing database I'm working on.
I have now sucessfully introduced the forex table and linked it to the principal 'sales' table which records details of all transactions. This produces the desired functionality to view sales data in any particular currency.
After implementing this change, the file size increased from 20mb to 45mb. This is not necessarily a problem, but I would like to know why. Can you offer any explanation?
Thu 10 Sep 2009, 15:25Trainer Stephen said...
RE: File size
Hi Vishal
Thank you for your question
Can you clarify the following for me?
We need to compare the size of the Forex table before it was imported with the size afterwards
Is there a significant difference between the size of the original database plus the Forex table compared with the size of the database after the import?
Thanks
Stephen
Thu 10 Sep 2009, 15:43Delegate Vishal said...
RE: File size
Yes, that would be 25mb.
The forex table is approximately 250 rows by 2 columns.
Thu 17 Sep 2009, 14:24Trainer Stephen said...
RE: File size
Hi Vishal
Thank you for your update.
I would suggest that given the size of the additional table, the overall increase in database size is not surprising.
You have more data in there. There will also be an increase in the "metadata", this is the data hidden within Access that describes the structure of tables, field types etc.
Hope this helps
Regards
Stephen
Thu 17 Sep 2009, 14:37Delegate Vishal said...
RE: File size
The size of the forex table is not very large, only c250 rows, and it led to database file size to double.
By contrast, the database already had tables which had rows in excess of 3000 rows.
This led me to believe there may be an error in the way I have linked the forex table to the rest of the database.
Thu 17 Sep 2009, 14:57Trainer Stephen said...
RE: File size
Hi Vishal
Without having site of the database it is difficult to identify if there is a problem.
I suggest the following checks
1. Check the design of the table. Do the field sizes make sense? For example if there are a number of text fields all set to a max length of 255 then this might go a long way to explaining it.
2. Does the table have a large number of blank fields? If so it might not be properly normalised and this could increase its size.
Regards
Stephen
Thu 24 Sep 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |
