Quote:
Originally Posted by sile2001
Madness. To think it normal that a somewhat widely-used application in 2023 doesn't support a mechanism that has been in Windows since 1995, Linux since the mid-to-late 90's (at least), and OSX since 2002. Got it.
|
Almost no applications designed to work with local files (includes USB) are reliable with Network shares, Windows or others.
Filesharing on Windows on NT or or ordinary windows just has batter security than 1993. Or MS LAN Manager on OS/2 from 1986. It's not safer for programs that are designed to use local files. Linux is technically the kernel. The rest is mostly GNU which started to be released from 1983. The Linux Kernel (only) was 1993, about the same time a complete NT 3.1 was released (the first version of NT).
Almost any application built on MS Access using MS tools will come to grief eventually if you use an Access database file on a Windows Share. You need full MS SQL , or Maria DB, or MySQL, or Oracle or DB2 etc, as a SERVER running remotely on the network. Then the application NEVER accesses files via a network share, but accesses a remote port on a server application on the remote computer, which then only accesses local files.
Calibre is single user, so it doesn't need the overhead of a database server. Thus it uses SQLight, which means Calibre is reading and writing the database files directly, not via a Server.
This is quite common for single user applications. The MS version of MS SQL starts with version 6.x in 1995. Previously it was Sybase. MS Access was released in 1993 and is still part of office. It will work over a share, but it's madness. You are meant to use MS SQL for a database on a network. In reality any Access database that works reliably on a Network or MS Cloud is actually being used like MS SQL, the actual physical file is only opened "locally" by a remote Server application (like Sharepoint).