Re: limiting/controlling MDB File Size
From: Mike Papageorge (mikep_at_itenergy.net)
Date: 02/23/04
- Next message: Linda: "Install ms office 2000 prof."
- Previous message: Mike Papageorge: "Re: Access 2000 vs Access 97"
- In reply to: vb: "limiting/controlling MDB File Size"
- Next in thread: vb: "Re: limiting/controlling MDB File Size"
- Reply: vb: "Re: limiting/controlling MDB File Size"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Feb 2004 16:04:10 -0000
you can't prevent the file from growing. access needs to do this as
information is cached. however, you can do things that help the overall size
of the file:
1. keep tables in a separate database and link you client end to it. the
client then stays a more stable size.
2. manage your temporary tables better
3. create a new access file and import all objects from the existing
database into that file. this helps clear out junk that builds up
4. create a new startup shortcut pointing to your access database and end it
with: ' /decompile'. load the app, let it decompile then recompile from a
code window and compact and repair. this is the best way to reduce size and
can make a difference that lasts for several weeks. you can then run the
decompile once a month or so
"vb" <anonymous@discussions.microsoft.com> wrote in message
news:14de701c3fa22$5e1df700$a001280a@phx.gbl...
> I developed an access application whose size keeps
> growing. I tried to delete the code/objects that I dont
> need but it still no use. Usually I compact the file at
> the end of the day.
>
> Is there a way that I can have a control of the size of
> the mdb file?
>
> thanks
> vb
- Next message: Linda: "Install ms office 2000 prof."
- Previous message: Mike Papageorge: "Re: Access 2000 vs Access 97"
- In reply to: vb: "limiting/controlling MDB File Size"
- Next in thread: vb: "Re: limiting/controlling MDB File Size"
- Reply: vb: "Re: limiting/controlling MDB File Size"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
