Re: [libreoffice-users] Base Help Anyone

On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder <alanpedder@hotmail.co.uk>
wrote:

> I
>  have been using Base to provide a database for my paintings via a
> simple form.  I recorded 200 records and then added the facility to
> include a photograph .jpg file and this is when the gremlins started to
> appear.
>
>
> It constantly issues error messages when adding data
> and causes me to endlessly loose work as it has failed to write to the
> table from a form for no obvious reason I can see, sometimes I can add a
>  new data or several set/records on the form OK and then it will fail
> with the error message as follows where the Table1 is my Table

Hello Alan. I haven't used Base to store binaries however I have monitored
this list for a while and used Base for a few small projects.

I expect the two primary recommendations you will get are...
1. Don't store data in Base, use a separate database back end because the
embedded HSQL is not very stable. To that end I've recently found the
native MySQL connector works well for me (never had reliable connections
with the Java or ODBC connectors).
2. Don't store binaries in Base, store a path/pointer to the binary. Keeps
the table size down, minimizes loss if the db becomes corrupted.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted