limiting/controlling MDB File Size

[vb]

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

 

[Mike Papageorge]

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

 

[Jamie]

Just click Start - Run and type: msaccess /decompile in the Run dialog.

Access will open - Browse to you access file as normal and open with this
instance of Access to decompile it.

Jamie

I do have the tables and the application(Front End ) in two different

databases. I tried to use /decompile as follows

msaccess existingdb.mdb /decompile newdb.mdb at the command prompt . I got

an error saying that the argument could not be identified.

 

[vb]

H
I did what you mentioned. All it is doing is creating another file with a 1 at the end of the file( test.mdb, test1.mdb). In fact the size of the file is increased now than before

May be I am missing something here

thank
vb