If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sudden increase in size
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. |
#2
|
|||
|
|||
"=?Utf-8?B?SmFtZXM=?=" wrote in
: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
WHY I CANNOT INCREASE ARABIC FONT SIZE, WHAT TO DO? | ESKIMO ZIM | General Discussion | 1 | January 21st, 2005 04:40 PM |
How do I increase the size of slides in 2 slides per page handout? | muitnep | Powerpoint | 2 | December 23rd, 2004 02:13 PM |
Increase in file size from Word 97 to Word 2003 | Newmanart | General Discussion | 2 | November 9th, 2004 09:22 PM |
How to increase the size of check boxes in Access forms/reports? | OutdoorVisions | Using Forms | 1 | October 23rd, 2004 12:55 PM |
Increase Size Of Auto Fliter Drop Down Box | Mathew | General Discussion | 1 | July 7th, 2004 05:28 AM |