Locked myself out of the DB with an Infinite Loop 1

[charlie12345]

I apparently have an infinite loop in one of my control procedures, so I can't get back into the DB to fix it. The DB is set to startup with opening the form, which then executes the loop. How do I get myself out of this? I need to get into the procedure code to fix the loop, but I don't know how without opening the DB.

Help!

Thanks,
Charlie

 

[BobStubbs]

Have you tried repeatedly pressing [Ctrl] and [Break] together, after starting the database? Depending on the type of loop, this may interrupt processing and give you a message with an [End] or [Cancel] button on it.


Bob Stubbs

 

[charlie12345]

Thanks!!!!!

 

[JeremyNYC]

Charlie,

Check out the link under Bob's signature...

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[strider72]

Try opening the database while holding down the shift key, which will pull up just the main database window. The go into the main Form in Design view and knock out the loop.

Steve