Front end hard crashing on open (linked table issue)

[emorris1000]

I have a front end where the path to the backend has changed. Should be easy to fix.

Except that now when I open the database it crashes out of Access. I get a series of "Object not found" or "Invalid Database Object Reference" errors in a row and then I get to a crashed macro from the Switchboard saying:

SwitchboardID, DLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")

Error 53

When I hit "Stop all macros" (my only option) I end up getting booted out of the database to the Access loading screen (for creating a new database.)

I think the mistake I made is that the switchboard has some extra listboxes on it that look into the linked tables. Or maybe there's something that closes Access when you exit the switchboard (although I don't think I put this in).

The problem is that I can't even look at the forms now. I can't look at the code. I can't change the path for the linked tables. I just go through this series of errors and then get booted out. If I "ctrl + break" my way through it I get an extra error from the switchboard (error 0) and then still get pushed through to this next error and get booted out.

Is there a way to open the database in a "safe mode" or a dead mode where the links are ignored or something? I can't even repair it in it's current state.

 

[AccessMSSQL]

Use F11!! When you open the database just hold F11 down. Then you can use the linked table manager to re-link the tables to the correct database path.

 

[ypma]

Is there a way to open the database in a "safe mode" or a dead mode where the links are ignored or something? I can't even repair it in it's current state.
In access 2003
When opening the db keep the shift button pressed and you should then be able to
access the design mode and code . Unless the db is a mde .
regards Ypma

 

[boblarson]

Yep, as ypma wrote, unless the database file is an mde/accde file AND the Shift Bypass key has NOT be disabled. You can hold the shift key down when opening the database. Make sure to keep holding the shift key down until the database fully opens.

 

[emorris1000]

Is there a way to open the database in a "safe mode" or a dead mode where the links are ignored or something? I can't even repair it in it's current state.
In access 2003
When opening the db keep the shift button pressed and you should then be able to
access the design mode and code . Unless the db is a mde .
regards Ypma

F11 didn't work, but this did.

Really saved my butt, thanks much. Now I just need to put something in that will sort this on its own.

 

[ypma]

Thank you for replying to my tip, its great when advise is acknowleged even if not its not used.
AccessMSSQL tip on the F11 could be needed when you are re-linking to the back end
Regards Ypma