Access DB not opening if specific drive letter not mapped

[nomsalis]

Hello all, I've inherited a few Access DB monstrosities. One of which had ODBC credentials hard coded in the MDE which I had to recently update due to some server updates. I found an unsplit version of the Access DB on a development drive (j:\db\...) and updated the credentials hard coded in VB and updated the linked tables from the J drive path (dev) to the K drive path (prod). I then split the DB and the MDE worked fine for me. I quickly found out that it only works fine because I had J mapped still. End users do not have the J drive mapped (development) only the K (production). Without the J drive mapped to the actual dev path the Access DB simply doesn't load. No errors.



I then tried to find any references to J in VB and fix those. At this point I can't seem to find anything else that could be referencing the J drive but still the DB will not open without J mapped. I really haven't used Access in years so I'm hoping I'm missing something simple. Any ideas would be greatly appreciated. Thanks!

[ssanfu]

Welcome to the forum..

Since you say the dB is split (good!), the tables are probably still linked to the wrong drive.
In the FE, hold the cursor over a linked table and a tool tip appear showing you the path the table is mapped to.

You will probably have to re-link the tables. Try the linked table manager.

[nomsalis]

Thanks for the response Steve!

Yah, I've already updated all the table links via the "Linked Table Manager" to the correct path. I've looked through all the VB for an file references but no luck. I'm wondering if a linked table may exist that the linked table manager doesn't see?

[ssanfu]

I'll take a look at your dB if you want to post it - just the FE.


I found this form years ago to see what the linked table paths are. I have modified it a little, but the copyright is there.
Import this one form into your FE, then look at the linked tables. The form name is "_See_BE_Links".