Bypass linking tables upon open

[seaBreeze]

Hello - how can I bypass linked tables when testing an existing Access 365 database? The DB has linked tables that are all broken links and upon open, it immediately tries to connect and the "A data file for the system cannot be found" message pops up and will not let me continue. I am trying to get to the VBA and even shortcuts to open the VB Editor do not work. Any help???

[ranman256]

If you access a table ,you'll get a broken link error.
i have 3 versions of each table:
tClient
tClient test
tClient prod

the Test is linked to a test db,
the prod to production,
I click a button,Test or Prod,that copies all Test tables to their normal name: tClient.

Would this work for your problem?

[seaBreeze]

I have inherited this DB and I can't even open it. It immediately starts to error out as it's trying to link tables which the path is broken.

1) Shift while opening does not work
2) Alt F11 does not open editor
3) Ctrl R R does not stop the VB code.

How do I simply open this DB and look at the Editor for the code? The error messages are written by the prior user as msgboxs.

[Micron]

what is the extension of the db file, accde, mde, mdb, accdb...?

[seaBreeze]

It is a accdb.

[Micron]

OK, asked because if it was accde or mde, this would be an entirely different scenario, aka 'you'd be dead in the water' with respect to that particular file.
However, things still are not clear. The message seems like a custom one because the closest I could find was "The System Cannot find the File Specified" which indicates a Windows issue. Also, "message pops up and will not let me continue" doesn't really support that idea because if you couldn't continue, you wouldn't be able to try any of the shortcut key combinations.

Saying all the links are broken implies that you can see the navigation pane?? If that is the case, can you not
- get at the ribbon (File tab) and alter any shortcut settings or disable any opening form that might be calling on one of the linked tables?
- see what the linked paths are (you mouse over them) and fix that problem by restoring them in the expected place?

If none of that helps, perhaps you will have to be much clearer about what happens. Or you could post the db here and I'll see if I can remove the bypass key setting (you seem to be saying the opening can't be bypassed) and you can take it from there. I don't think it would be prudent of me to advertise how to do that, otherwise I think I'd be circumventing a lot of people's efforts when they are relying on it.

[seaBreeze]

Let me try to be more clearer. Sorry for any confusion. Friday at 644pm hahaa

Yes the messages are custom msboxs.
(I realized this after my initial post) As soon as the DB opens, the links are refreshed and it can’t find the files so it’s errors out. I can sort this out once I can see the code.

My bigger concern is I cannot get to the navigation or any ribbons.
None of the keyboard shortcuts work to

1) view editor
2) halt any execution of code

More details above on that.

I would like to look at the code and I can’t get to anything. It simply opens to a form and custom messages try to link the tables and it fails since the files aren’t there. This is when I tried all the shortcuts to no avail.

Can you email me some info if it’s not possible to post publicly? Are you saying the shift is not the bypass key and some other key is custom assigned?

[Micron]

I pm'd seabreeze with instructions that would be known to many here. That is because I prefer not to advertise en masse on how to circumvent any of the things a developer might do to implement any level of security. Sure, the info is readily available if you know what to look for, but I prefer to judge each case on its own merits as to whether or not I'll teach somebody how to get past it. All I can do is ask the person in need to do the same.

I received a note saying that part of the problem is solved, so hopefully, seabreeze will mark this as solved. I think if there's a different issue that arises, it should be a new thread, but that's just me.

[seaBreeze]

Yes - marked solved! Thank you again!