Sudden increase in size

[James]

Hello all
I have a database with 48 forms and 15 tables. Only about 10 test data
records in. It has been staying around 8mb for a while as I add coding etc.
I have just added one field to one of the tables and a paragraph of code to
one of the forms to create SQL statement to update the field.
The size as now jumped to 76mb! It works but is a bit slow loading up now.
Can anyone give a reason or some advice?
Many thanks, James.

 

[Tim Ferguson]

I have just added one field to one of the tables

This will create in the file a copy of the original table along with
various editing structures. This will all take up space, which is not
automagically recovered unless you ask it:-

1 Run Repair and Compact to recover deleted space

2 You are way under the 2MB limit at which curruption becomes likely, so
who cares?

3 You might care, actually: it's considered good practice to repair and
compact active databases on a regular basis

4 But make a backup first, as it's not unknown for the repair & compact
to corrupt the file itself!

All the best


Tim F