MyAccess doc got too large!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello. I am new to Access, but I've learned a lot during these past two
weeks - slowly building a form, which is ending up to be a tabbed form, since
I exceeded the "vertical limit". Anyway, so I've been designing and
deleting, and re-designing...

I'm curious: whenever I re-do something, am I creating code somewhere in the
background, and making this whole big mess? My document is now more than
10,692 KBs in size!!!!! It's a form with 5 tabs, lots of option buttons,
text spaces..etc. NO graphics.

Is this the size you would expect? Or is something wierd happening because
I've re-designed the same form so many times?

Do I have to start over fresh to have a smaller doc?
 
Stilla said:
hello. I am new to Access, but I've learned a lot during these past two
weeks - slowly building a form, which is ending up to be a tabbed form, since
I exceeded the "vertical limit". Anyway, so I've been designing and
deleting, and re-designing...

I'm curious: whenever I re-do something, am I creating code somewhere in the
background, and making this whole big mess? My document is now more than
10,692 KBs in size!!!!! It's a form with 5 tabs, lots of option buttons,
text spaces..etc. NO graphics.

Is this the size you would expect? Or is something wierd happening because
I've re-designed the same form so many times?

Do I have to start over fresh to have a smaller doc?
Click to expand...

Make a copy of the mdb file just for safe keeping then go to tools >
database utilities then compact and repair.

gls858
 
hello. I am new to Access, but I've learned a lot during these past two
weeks - slowly building a form, which is ending up to be a tabbed form, since
I exceeded the "vertical limit". Anyway, so I've been designing and
deleting, and re-designing...

I'm curious: whenever I re-do something, am I creating code somewhere in the
background, and making this whole big mess? My document is now more than
10,692 KBs in size!!!!! It's a form with 5 tabs, lots of option buttons,
text spaces..etc. NO graphics.

Is this the size you would expect? Or is something wierd happening because
I've re-designed the same form so many times?

Do I have to start over fresh to have a smaller doc?
Click to expand...

First off... a .mdb database Is Not A Document, and thinking of it as
if it were one will get you in trouble. It's a container for multiple
objects - Tables, Forms, Queries, and so on.

Secondly, 10 MByte is pretty small. 2,000,000 KByte is too big, but
you have a long way to go.

Finally... Tools... Database Utilities... Compact and Repair Database
will recover all the waste space left by your editing activities.
Access doesn't recover this space on its own.

Do make a backup first (before compacting, and before making any
changes to the database that you would object to redoing).

John W. Vinson[MVP]
 
Thank YOU!! I've done it and it shrank to 525kbs !! So far, it's really
just a form, an empty "main data table" and another table where my drop down
menu options reside.

Yes, I do need to start thinking in a different way about Access - to stuck
on the document idea.

Stilla
 
Back
Top