The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » File size

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

File size

Resolved · Low Priority · Version 2003

ReplyThu 10 Sep 2009, 11:06Delegate Vishal said...

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?

For upcoming training course dates see: Pricing & availability

ReplyThu 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

ReplyThu 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.

ReplyThu 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

ReplyThu 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.

ReplyThu 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.

Access articles

· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· A Greater Understanding Of Your Business With Access Reports
· Happy Table Relationships In Access 2007
· Discover How To Link An Excel Spreadsheet To An Access Database
· How much time could you save with Access?

Please browse our web site to find out more about
access/courses and other Microsoft training courses.

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

How do you send a html page as an email using dreamweaver?