MS Access Crashing after import

[dotolee]

Hi there.

I'm trying to get around the error that I have too many controls on my form - I need to add a button to my form. i know i don't have more than 700 controls.
Someone suggested that i create a blank database and import everything in as this would "reset" the number of controls.
I've done that but when i try to run the form in the new database as a test, MS Access crashes. The original database however, is ok (although I'm sure that doesn't mean it doesn't have problems)
Any suggestions?

 

[dotolee]

I also tried:

- creating a copy of the database;
- doing a save as on the form and saving with a new name;
- delete the orig form;
- rename the new form to original name;

This still causes the entire database to crash when i try to run the form.

 

[RoyVidar]

Sounds like corruption of some kind.

I'd suggest something along the lines of the following,

Create a copy of the db, and hit ctrl+g and in the immediate window, type or copy/paste

[tt]application.saveastext acform, "<name of form>", "c:\tst.txt"[/tt]

Then create a new database where you import all the other objects, but not this form.

Then, again, hit ctrl+g and in the in the immediate window, type or copy/paste

[tt]application.loadfromtext acform, "<name of form>", "c:\tst.txt"[/tt]

Then, while in the VBE, select Debug | Compile (which hopefuly works), then save.

Roy-Vidar

 

[dotolee]

ok. i just did something similar where I saved the form as text to a "temp.txt" and then tried to loadfromtext into the SAME database (but a new form). It didn't work...

I will try the blank database approach.... and the compile

 

[dotolee]

Hi again.
I just tried creating the blank database, importing everything except for the form in question.
create the form using the loadfromtext option. the form was generated.. but when i try to run it, after rendering for 2 seconds, the database crashes.

 

[RoyVidar]

Then I don't know, I'm afraid, but another suggestion could be to have a look at what Allen Browne says about Access flaws, were some might give crashes - see the flaws section here

http://allenbrowne.com/tips.html

One of the more important, is to turn the Name AutoCorrect off

Roy-Vidar

 

[dotolee]

thanks for trying though RoyVidar. I never use the Name AutoCorrect...
I'll take a look at the site you've posted.
thanks again.