Access Says It Can't Find My Database - Even Though It's There!

[michaeltrombetta]

I accepted MS's offer of additional storage space in the cloud, and it screwed up 3 databases I've been using for 20+ years. I managed to fix most problems, but now Access says it can't find my database (I have separate database and forms files. I open the forms file, and change to design view. There I select External Data, and Import. There I select Access. A window opens with the correct path C:\Users\Mickey\OneDrive\Documents\Sync Folder\. I click Browse, and select the right file, Local_MusicTables.mdb. I choose Link and click OK. The next screen shows all the tables, and I click Select all, and OK. I am returned to the Access window, with all the tables, forms, etc listed on the right column. That looks great, but when I go back to Forms view and click and action Add Albums, I get the message Could not find the file, followed by the complete path to the file I just clicked on.

[isladogs]

With regard to databases, cloud storage should only ever be used for that - storage!
NEVER run an Access database on OneDrive, Dropbox etc for the same reason as you should never do so using Wifi.
You will get network connection dropouts which carries a High risk of data corruption.

Copy both FE and BE to your hard drive. Relink the BE tables. Then try again

[michaeltrombetta]

I THOUGHT I was adding OneDrive storage just for backup, but File Explored showed me that my Access files were MOVED to OneDrive! I copied them back to my original folder, and now things are OK.

[isladogs]

Its a mistake that's far too easy to make.
I've also deleted what I thought were backup copies of apps when my OneDrive storage was almost full. Turned out several items were the only copy I had