File Size 200Mb Why?????

[ian.tiesdell]

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

[Fred Zuckerman]

<ia**********@hotmail.co.ukwrote in message
news:96**********************************@e10g2000 prf.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

[Allen Browne]

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" <Zu********@sbcglobal.netwrote in message
news:w7****************@newssvr19.news.prodigy.net ...

<ia**********@hotmail.co.ukwrote in message
news:96**********************************@e10g2000 prf.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

[lyle fairfield]

ia**********@hotmail.co.uk wrote in news:96b63589-6e41-4298-b7ed-
3f**********@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_...ts_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.

[Don Calloway]

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

<ia**********@hotmail.co.ukwrote in message
news:96b63589-6e41-4298-

b7***************@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.