Why is access .mdb file so huge?

[Pieter Wijnen]

..... unicode, compile on demand

resolution:
Open the database with the /DECOMPILE switch (+SHIFT key)
close db
compact & hey presto
make a backup first!!!! (totally undocumented switch)

HTH

--
Pieter Wijnen

When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca
http://allenbrowne.com/

 

[hin87_at_yahoo.com]

I found out that if I have pictures embedded on the report, your mdb
file increase. Try linking your pcitures instead of embedding.

After I removed the pictures, my mdb file went from 56MB to 5 MB.

Now, my only problem is that Access crash often when I'm trying to
view the reports.

 

[Bruce M. Thompson]

(totally undocumented switch)

Semi-documented switch. Microsoft does mention it in at least one article on
dealing with database corruption and it is *well* documented in the newsgroups
(and the google archives).

 

[Pieter Wijnen]

I wasn't aware that microsoft finally has admitted to it's existence ....

(been busy elsewhere for a long time)

Pieter

 

[Ivan Starr]

Hello, thank you for trying to help.

I have an access front end to an SQL server database. There are only a
handful of forms, reports, and a module, all of moderate size. All my
tables are 'linked' tables to the SQL server tables.

THE FILE IS OVER 14MB AFTER COMPACTING!

It also takes a long time for Access to save a report after it has been
modified in design view.

Anyone know what's going on?

Thanks,

Ivan

 

[Bruce M. Thompson]

I wasn't aware that microsoft finally has admitted to it's existence ....

(been busy elsewhere for a long time)

That's okay. It's still unsupported, though (that means that you use it at your
own peril).