Front end won't compact. Need help refreshing bloated form.

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

Hi all,

I am in a pickle. I have an access front-end with a couple relatively
advanced user forms which connect via linked tables to a mySQL
backend. In the past couple weeks I have made changes that have
caused one particular form in my front end to bloat terribly (from 2
MB to 24 MB). This has happened in the past and i was able to fix the
problem by
1. saving the form as text (using VBA).
2. deleting the existing form
3. importing the form from text (using VBA).

I used two VBA commands to do this, but in searching the web for a
couple hours, I have not been able to find those functions. Is anyone
familiar with the problem and could let me know what functions I need
to use to export my form as a text file and then import it in the
immediate window?

Much appreciation,

Sam
 
Sam said:
Hi all,

I am in a pickle. I have an access front-end with a couple relatively
advanced user forms which connect via linked tables to a mySQL
backend. In the past couple weeks I have made changes that have
caused one particular form in my front end to bloat terribly (from 2
MB to 24 MB).
Click to expand...

Out of curiosity, what makes you think the form has bloated? How have you
determined the storage required for the form?
This has happened in the past and i was able to fix the
problem by
1. saving the form as text (using VBA).
2. deleting the existing form
3. importing the form from text (using VBA).

I used two VBA commands to do this, but in searching the web for a
couple hours, I have not been able to find those functions. Is anyone
familiar with the problem and could let me know what functions I need
to use to export my form as a text file and then import it in the
immediate window?
Click to expand...

I believe you're looking for:

Application.SaveAsText

Application.LoadFromText

They are hidden methods, but once you've typed in their names and hit the
space bar, the intellisense will appear to guide you the rest of the way.
 
Out of curiosity, what makes you think the form has bloated?  How have you
determined the storage required for the form?



I believe you're looking for:

    Application.SaveAsText

    Application.LoadFromText

They are hidden methods, but once you've typed in their names and hit the
space bar, the intellisense will appear to guide you the rest of the way.
Click to expand...

Dirk, you are an absolute life saver. It worked perfectly. Now my
database is back to normal. Thank you.
 
Back
Top