Endless Loop on Start-up Form crashing database.

[PoolGuy]

A form that i have set to open automatically at start-up mistakenly had a
requery added to its 'On Current' event. This is causing an endless loop
preventing the form from opening and causing the database to crash before
opening. I need to be able to open the database to fix the problem.
Is there a way to open the database without having the start-up form initiate?
Is there a way to access the progamming without opening the database?
Is there a way to alter the start-up form without opening the database?
Is it possible to stop the query before it crashes the database?

Thanks

 

[Jeanette Cunningham]

Hi PoolGuy,
hold down the shift key while opening the database and until the database is
open.
Now you can open the startup form in design view and change the code.



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[PoolGuy]

Thanks Jeanette. My only other option would have been to overwrite the form
in question with my back-up copy (2 wks old). This saved some work!

 

[Sylvain Lafontaine]

Your third option would have be to import everything into a blank database.
Also, you should know by now that making backup copies every two weeks is
insufficient.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[aurelio martinez]

A form that i have set to open automatically at start-up mistakenly had a
requery added to its 'On Current' event. This is causing an endless loop
preventing the form from opening and causing the database to crash before
opening. I need to be able to open the database to fix the problem.
Is there a way to open the database without having the start-up form
initiate?
Is there a way to access the progamming without opening the database?
Is there a way to alter the start-up form without opening the database?
Is it possible to stop the query before it crashes the database?

Thanks