How can I attach a file (PDF, DOC, JPG, MP3, etc…) to a record in LibreOffice Base? In MS Access, I could just create a table for files and then make an OLE Object spot and then in a form I could just attach a file and go to the next record. The database is used as a customer management application; notes, files, general information, etc… will be stored in this database.
Hi Anon,
Please take a look at my Answer to this question:
The linked video has two parts
- Part 1 explains how to embed files in a database
- Part 2 explains how to link to files from a database
I believe that in nearly all cases you’re best served by linking to files. That keeps them out of the database (making the db smaller) and means that even if the db goes belly-up, you can still access all of your files!
Is there any database type where the risk of running out of memory or having the DB crash is not a concern for when attaching files?