MDB Size

[Chedva]

I have an application that was in Acc97, The application is using
complicates views which enlarge the size of the FE mdb every time it is
used. I used to run /repair /compact every time the system loaded so that it
didn't get to large. Now I converted it into Acc2K and I find that the
compact and repair util doesn't decrise the size of the MDB. I tried the
/decompile but it didn't help. What can i do??

 

[Van T. Dinh]

Have you tried the Compact-on-Close option (new in A2K0)?

I think /Decompile only removes the compiled code so it won't make much
difference in the MDB size. I only use the /Decompile switch when something
is drastically wrong with the database.

 

[david epsom dot com dot au]

compact and repair util doesn't decrise the size of the MDB.

You now must use Access to do a complete compact. The compact
and repair util can't do a complete compact of an Access 2K
database.

(david)