# Link Joplin to sqlite file (again)

**URL:** <https://discourse.joplinapp.org/t/link-joplin-to-sqlite-file-again/33146>\
**Category:** Support\
**Created:** [14 October 2023 16:03 UTC](https://discourse.joplinapp.org/t/link-joplin-to-sqlite-file-again/33146 "2023-10-14T16:03:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dabadan](https://avatars.discourse-cdn.com/v4/letter/d/d07c76/32.png) [@dabadan](https://discourse.joplinapp.org/u/dabadan)\
**Post date:** [14 October 2023 16:03 UTC](https://discourse.joplinapp.org/t/link-joplin-to-sqlite-file-again/33146/1 "2023-10-14T16:03:06Z")

</div>

Hi,  
I am on Windows 11, Joplin 2.12.18 (prod, win32). Until recently, I had my Joplin synced with my OneDrive. Then I had to delete files from my OneDrive. Initially, I had no problem.

Today, upon reopening Joplin, none of my notes are shown within the Joplin interface. Since I had the sync failsafe activated, I do not believe any local files were deleted when the files were deleted from OneDrive.

I do know where the local database.sqlite file is stored on my PC (default location). The sqlite file contains 14,968 KB.

Under synchronization in general settings, I deactivated the synchronisation target for now (None).

How can I make joplin show me the notebooks and notes that should be stored in my local copy of the files again?

Please help!

Thank you.

---

<div class="post-metadata">

**Author:** ![tomasz86](https://avatars.discourse-cdn.com/v4/letter/t/96bed5/32.png) [@tomasz86](https://discourse.joplinapp.org/u/tomasz86)\
**Post date:** [14 October 2023 17:20 UTC](https://discourse.joplinapp.org/t/link-joplin-to-sqlite-file-again/33146/2 "2023-10-14T17:20:47Z")

</div>

Joplin always stores notes in the sqlite database file, regardless of whether you use synchronisation or not. If you don't see any notes, then this likely means that they aren't present in the database either. Judging by what you've written above, it's likely that you will need to undelete your notes using the method from [https://discourse.joplinapp.org/t/restoring-deleted-notes](https://discourse.joplinapp.org/t/restoring-deleted-notes). However, this will only work if you had note history enabled and not enough time has passed to remove them from the database permanently.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex028/uploads/cozic/original/3X/1/c/1c948e33314e232a0927789508474d8624f4270b.png) [@system](https://discourse.joplinapp.org/u/system)\
**Post date:** [13 November 2023 17:21 UTC](https://discourse.joplinapp.org/t/link-joplin-to-sqlite-file-again/33146/3 "2023-11-13T17:21:15Z")

</div>

Closed on 13 November 2023 17:21 UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
