In MSAccess 2003, how to fix the "Not responding" file open, import or link window.

Answering my own question because I found this solution...

In this case, the problem seems to be related to OneDrive and the default location of the "Documents" folder. When using the file explorer window (File Open, Import or Link data, etc.), it opens by default in the current user Documents folder. If that folder is in OneDrive, it stalls. You'll then have to end the process via the Task Manager or simply click on the X to close it and let windows handle the crash.

By default on a new installation of Windows 11, unless you micromanage that aspect, OneDrive is putting itself as the manager of the user default folders : Documents, Pictures, Music; etc. It would appear that MSAccess 2003 really doesn't like that.

By following the instructions of the accepted answer from this question : https://learn.microsoft.com/en-us/answers/questions/5316603/cant-move-my-documents-folder-thanks-to-one-drive

You bring back your user folders to being local instead of "online" and after that, Access can use the file explorer normally. It doesn't hang or crashes.

You don't necessarily have to move the documents to another place or drive like in the linked solution. By simply turning off the OneDrive backup and revert the Documents path to local instead of on OneDrive, it should fix the issue. It worked for me.

1. Turn off OneDrive backup for at least the Documents folder.
2. Return the Registry to default directories (like in the linked solution above)
3. Reboot
4. OPTIONAL : Then use the location function to move your folders where you want them to be. But that's not necessary.

Be careful though, make backups of your content before doing anything.

Best...

Dear FD-5007

Welcome to the Microsoft Q&A Forum and thanks for reaching out to share your issue.

I truly appreciate your thoughtful and detailed explanation regarding the issue with OneDrive’s default folder mapping interfering with legacy applications like Access 2003. Your insight into how these changes impact older software, and your clear walkthrough of the solution, are incredibly helpful.

This discussion will surely be a valuable reference for other users facing similar challenges. Personally, your post has not only improved my understanding of the root cause but also equipped me with the practical knowledge to assist others in resolving it.

Your contribution adds meaningful value to our community and strengthens the collective knowledge we share. Thank you again for taking the time to support others through your experience.

Wishing you a pleasant day ahead!

Keep in mind that MS Access 2003, which I assume you have as part of Office 2003, is more than 20 year old software. A very long time indeed in the software world. Office 2003 was designed several years before SkyDrive, the predecessor to OneDrive, was dreamt up. Therefore, it's not unsurprising at all to learn that there are incompatibilities between the two.

While it's possible, and in some cases, desirable to use out-of-support software like Access 2003, doing some comes with its own unique challenges. Fortunately, you did figure out how to manage those challenges.

Continued success with your project. Maybe take a look at Access 2024, though?