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?
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
RE: File size
Yes, that would be 25mb.
The forex table is approximately 250 rows by 2 columns.
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
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.
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
