Endless Loop on Start-up Form crashing database.

P

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
 
J

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
 
P

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!
 
S

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)
 
A

aurelio martinez

PoolGuy said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Need some PWA help 0
Visio 2019 crashes when attempting to open drawing. 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Internal Data Integrity (Type 4) Details Needed 1
Database badly damaged 0
Open an Access Database to work on 4

Top