Hello,

I have a database front-end that has recently jumped from a lowely 3mb
to over 50mb. Is there anything normal that can cause this to
happen? The file in question contains only forms, reports, and
queries. All of the tables are split between 3 seperate back-ends,
for security purposes, with the FE linked to them. I have already
scrubbed the FE for redundant and unneded forms, reports, queries, and
code.

Have you compacted the database?
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"martinmike2" wrote:

> Hello,
>
> I have a database front-end that has recently jumped from a lowely 3mb
> to over 50mb. Is there anything normal that can cause this to
> happen? The file in question contains only forms, reports, and
> queries. All of the tables are split between 3 seperate back-ends,
> for security purposes, with the FE linked to them. I have already
> scrubbed the FE for redundant and unneded forms, reports, queries, and
> code.
>

>
>
>
> Dale,

Its 50+mb after I compact, lol

Did you make any changes to the database application?

Did you add any pictures to the database application? Pictures can bloat the
application fairly quickly.

Did you try decompile, compact, compile, compact? Make a backup first.

See Allen Browne's site for recovering from corruption. Your database is
probably not corrupted, but following the steps for decompile, compact,
compile, compact should get the database down to minimum size.
http://allenbrowne.com/ser-47.html

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

martinmike2 wrote:
>>
>>
>> Dale,
>
> Its 50+mb after I compact, lol

On Mon, 25 Aug 2008 05:01:50 -0700 (PDT), martinmike2
<martinmike2@gmail.com> wrote:

You may have redundant compilations in your project. Compact,
/decompile, and Compact again.
Another option is to export all objects to text files and import them
again, using SaveAsText, LoadFromText.

-Tom.
Microsoft Access MVP


>Hello,
>
>I have a database front-end that has recently jumped from a lowely 3mb
>to over 50mb. Is there anything normal that can cause this to
>happen? The file in question contains only forms, reports, and
>queries. All of the tables are split between 3 seperate back-ends,
>for security purposes, with the FE linked to them. I have already
>scrubbed the FE for redundant and unneded forms, reports, queries, and
>code.

we have pictures stored in a seperate folder and only the path to them
stored in the database, not the actual picture. as far as
decompiling, I am on a company computer that is completely locked out,
even mtyping cmd in "RUN" dosnt bring up the command prompt, lol.

I've got similar problems, but I get around it by creating a txt file with a
..BAT extension. Then I've got one line of code that decomplies my
application.

"C:\Program Files\Microsoft Office\Office12\ MSACCESS.EXE"
"C:\Work\MyApp.mdb" /decompile

Watch the word wrap.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"martinmike2" wrote:

> we have pictures stored in a seperate folder and only the path to them
> stored in the database, not the actual picture. as far as
> decompiling, I am on a company computer that is completely locked out,
> even mtyping cmd in "RUN" dosnt bring up the command prompt, lol.
>

Tried that Dale,

It opened the file then I compacted, no change.

even tried JetComp, no change.

having a moderate amount of sub queries and subforms wouldnt cause
this issue would it?

No, most of my large databases (where I have split the front and back ends)
only result in 3-4 Meg front ends (and that is with lots of forms, queries
and reports). Generally, the front ends are much smaller than that.

Have you tried creating a new db, then importing all of the objects from the
old one into the new one? If you do this, make sure you don't forget to
import any of the
import specs or menus you have created in the old db.

Is there a chance you imported a table rather than linking to it?


--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"martinmike2" wrote:

> even tried JetComp, no change.
>
> having a moderate amount of sub queries and subforms wouldnt cause
> this issue would it?
>
>