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

<ian.tiesdell (AT) hotmail (DOT) co.uk> wrote

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

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" <ZuckermanF (AT) sbcglobal (DOT) net> wrote

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

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.