File Size 200Mb Why?????

Hi

I have a database which has linked tables, none stored locally - it
has a size when compacted of nearly 200Mb

it comprises 21 queries, 26 forms and 2 reports - there are no
embedded images and very little code on the forms

does anyone have any suggestions as to why the file should be so big -
i have other applications none of which exceed 15mb even with locally
stored data and a similar number of forms

the size makes it a real pain to drag around a network

Many Thanks

Re: File Size 200Mb Why?????

wrote in message
news:96b63589-6e41-4298-b7ed-3f03e54dfaa4@e10g2000prf.google groups.com...
> Hi
>
> I have a database which has linked tables, none stored locally - it
> has a size when compacted of nearly 200Mb
>
> it comprises 21 queries, 26 forms and 2 reports - there are no
> embedded images and very little code on the forms
>
> does anyone have any suggestions as to why the file should be so big -
> i have other applications none of which exceed 15mb even with locally
> stored data and a similar number of forms
>
> the size makes it a real pain to drag around a network
>
> Many Thanks

I can't explain why, but it does seem unreasonable.
Try the following:
1. Create another empty database
2. Using File -> Get External Data -> Import
3. Select All (tables, queries, forms, & reports)
4. Compact & Repair
6. Let us know the resulting size
Fred Zuckerman

Re: File Size 200Mb Why?????

In addtion to Fred's advice, you might like to:

a) Decompile and compact the existing database before step 1.

b) Turn off the Name AutoCorrect options in the new database at the end of
Step 1.

To decompile, enter something like this at the command prompt while Access
is not running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

To compact, go to:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

To turn off Name AutoCorrect, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Fred Zuckerman" wrote in message
news:w7ifj.3944$lo5.700@newssvr19.news.prodigy.net...
> wrote in message
> news:96b63589-6e41-4298-b7ed-3f03e54dfaa4@e10g2000prf.google groups.com...
>> Hi
>>
>> I have a database which has linked tables, none stored locally - it
>> has a size when compacted of nearly 200Mb
>>
>> it comprises 21 queries, 26 forms and 2 reports - there are no
>> embedded images and very little code on the forms
>>
>> does anyone have any suggestions as to why the file should be so big -
>> i have other applications none of which exceed 15mb even with locally
>> stored data and a similar number of forms
>>
>> the size makes it a real pain to drag around a network
>>
>> Many Thanks
>
> I can't explain why, but it does seem unreasonable.
> Try the following:
> 1. Create another empty database
> 2. Using File -> Get External Data -> Import
> 3. Select All (tables, queries, forms, & reports)
> 4. Compact & Repair
> 6. Let us know the resulting size
> Fred Zuckerman

Re: File Size 200Mb Why?????

ian.tiesdell@hotmail.co.uk wrote in news:96b63589-6e41-4298-b7ed-
3f03e54dfaa4@e10g2000prf.googlegroups.com:

> Hi
>
> I have a database which has linked tables, none stored locally - it
> has a size when compacted of nearly 200Mb
>
> it comprises 21 queries, 26 forms and 2 reports - there are no
> embedded images and very little code on the forms
>
> does anyone have any suggestions as to why the file should be so big -
> i have other applications none of which exceed 15mb even with locally
> stored data and a similar number of forms
>
> the size makes it a real pain to drag around a network
>
> Many Thanks

You might consider running this code

http://www.ffdba.com/downloads/Save_MDB_Objects_As_Text.htm

in a !!!!!copy!!!!! of your db to see what size new mdb is created. TTBOMK
this makes as small a copy as you can get. The new DB will be found in a
"As_TextYYYYMMDD" subfolder.

Re: File Size 200Mb Why?????

On Thu, 03 Jan 2008 19:59:02 -0800, Fred Zuckerman wrote:

> wrote in message
> news:96b63589-6e41-4298-
b7ed-3f03e54dfaa4@e10g2000prf.googlegroups.com...
>> Hi
>>
>> I have a database which has linked tables, none stored locally - it has
>> a size when compacted of nearly 200Mb
>>
>> it comprises 21 queries, 26 forms and 2 reports - there are no embedded
>> images and very little code on the forms
>>
>> does anyone have any suggestions as to why the file should be so big -
>> i have other applications none of which exceed 15mb even with locally
>> stored data and a similar number of forms
>>
>> the size makes it a real pain to drag around a network
>>
>> Many Thanks
>
> I can't explain why, but it does seem unreasonable. Try the following:
> 1. Create another empty database
> 2. Using File -> Get External Data -> Import 3. Select All (tables,
> queries, forms, & reports) 4. Compact & Repair
> 6. Let us know the resulting size
> Fred Zuckerman

I've also noticed that when a db encounters problems and must close, for
example, the database size can double. Compacting and repairing will
usually bring the db back to its original size.