Access file grew up unexpectedly. Why?

  • Thread starter Thread starter S!mon
  • Start date Start date
S

S!mon

I have been improving my current Access DB (keeping previous versions).
The last time I had a problem - one button Add new record in my form did not
work. (Microsoft Office Access has encountered a problem and needs to close).
I did not use this button for a long time so I do not know which change may
impact.
I am trying to figure out what happened. I noticed:
1. My different versions have different size (6 MB and 600 MB?)
2. After changing something in design this form (not specially this button)
the button starts work. However after close and restart a program the button
problem comes again.
Any suggestions?
 
I had a similar problem with some spreadsheets. Check to make sure that the
program doesn't think that a lot of white space after the data is part of the
file, you can select the extra cells and delete them. You can select multiple
cells at once by selecting the first, holding shift, then clicking the last
one.
 
S!mon -

Have you compacted/repaired your database? See if that helps. If not, then
step through the code on the button (set a breakpoint at the first executable
line in the code), and see where the issue occurs.
 
I am done!
Now my form is working!!
Thank you!

Daryl S said:
S!mon -

Have you compacted/repaired your database? See if that helps. If not, then
step through the code on the button (set a breakpoint at the first executable
line in the code), and see where the issue occurs.
 
Back
Top