Re: Large file size

Tech-Archive recommends: Fix windows errors by optimizing your registry

Allen, Thank you so much for your response. Yes, I have compacted. Yes, I
have one image that is included in half a dozen of the reports. I suppose
that's what does it. Can I assume it's stored in each module? Can I make it
so it's stored only once? It's just a small logo (maybe 1 inch by 3 inches).

--
Jim


"Allen Browne" wrote:

Presumably you have already tried a compact:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

If you have any graphics in the database (e.g. Picture property of the form,
or Image controls), you could try removing those. The bloat the database
badly. (This is much less of a problem in Access 2007.) Then compact again.

If that has not solved it, decompile this database, and then import
everything into a new one:

1. Close Access. Make a backup copy of the file. Decompile the database by
entering 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"

2. Open Access (holding down the Shift key if you have any startup code),
and compact again.

3. Create a new database:
File | New

4. 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

5. Link the tables:
File | Get External | Link

6. Import the queries, forms, and modules from the old database.

--
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.

"JimS" <JimS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DDD38E43-53FE-4E46-93C8-C400E1AFDECB@xxxxxxxxxxxxxxxx
I have a front-end database with NO tables (only links), half-dozen
queries,
a dozen forms, and three code utility modules (all told, code is maybe 300
lines visible). It's taking up 122MB! Any idea why? Strategies?
--
Jim


.

Quantcast