Large database

[Ken]

My 2000 mdb file went from 5MB to 30MB overnight (for no apparent reason). Compact and Repair brings it down to around 28MB, but that still seems larger than it should be. Any advice

 

[gandalf]

1)you could import all objects in a new database and see
if it is still 28 mb

2)try the external jet compact utility from microsoft
3) you could try the undocumented /decompile switch (more
info on the internet)

great resources on access:
http://www.granite.ab.ca/access/corruptmdbs.htm
http://www.able-consulting.com/ado_conn.htm
http://www.mvps.org/access/api/api0001.htm

http://www.mvps.org/access/tables/tbl0009.htm
http://accdevel.tripod.com
http://members.rogers.com/douglas.j.steele/AccessReference
Errors.html
http://www.lebans.com/mousewheelonoff.htm
http://support.microsoft.com/?id=258049
http://www.mvps.org/access/general/gen0005.htm
http://www.trigeminal.com/usenet/usenet001.asp?1033
http://www.pksolutions.com

mailmerge

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html


http://appdevissues.tripod.com

inventory control:
http://members.iinet.net.au/~allenbrowne/AppInventory.html

-----Original Message-----
My 2000 mdb file went from 5MB to 30MB overnight (for no

apparent reason). Compact and Repair brings it down to
around 28MB, but that still seems larger than it should
be. Any advice?