Hello, I work with Base (stand alone) as well since many years, the main application with it has several thousand records. However my experience is that base is less stable compared to e.g. LO Calc or LO Writer. My most critical app is still in ACCESS and I will change that to MariaDB.

As like for any other application the rule of doing a backup is simple: Do the backup before the amount of data entry/edit you don't want to do again.

I have an app on an external drive and use the internal drive as backup drive by using 'Save As...' and use the following file name convention, e.g. for today it would be:
MXDB_2024-0101A.odb
MXDB_2024-0101B.odb

for tomorrow:
MXDB_2024-0102A.odb
MXDB_2024-0102B.odb
etc.

Happy hew year to all!
Hanspeter

On 01.01.24 00:12, Harvey Nimmo wrote:
Don't give up...Base is a powerful tool for managing all kinds of data.
and Robert Großkopf is an excellent advisor!

Happy new year to all!
Harvey


On Sun, 2023-12-31 at 13:43 -0500, Jonathan Ames wrote:
In trying to reopen table I'd created, I cannot add records -- says
ERROR
"Attempt to insert null into a non-nullable column: column: Key
table:
Owntunes in statement [INSERT INTO "Owntunes" ( "Pubdomain?","Song")
VALUES
( ?,?)]--" anyway I don't know what it means. The table is "Owntunes.
All I
did was try to begin a new record.I also get a very small red icon
containing an "I" with a slash through it, near top left of "open
database". Manual "Base" section doesn't cover this. Using MAC OS
Sonoma.
Have Java on computer. Wondering if I will really have to learn to
code if
I want sort of consumer database formerly available (e.g., Lotus
Approach)
-- I'm 77. New to LibreOffice: is understanding and responding to
such as
above required for use?

Sort of like the following learning curve:


    1. - Databases store and manipulate data.
    2. - Data can be numeric or verbal.
    3. - E = MC2

Do other folks give up on LibreOffice Base as too technical? Any idea
where
they end up?

Thanks

Jonathan

Jonathan Ames, PhD
Clinical Psychologist
607-227-4792 - Cell
jnthn.a...@gmail.com
www.whatnowconnect.com


Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be
subject
to protection under the law, including the Health Insurance
Portability and
Accountability Act (HIPAA). The message included in this email is for
the
sole use of the intended individual or entity to whom it is
addressed. If
you are not the intended recipient, you are notified that any use,
distribution or copying of the message is strictly prohibited and you
may
be subject to criminal or civil penalties. If you received this
transmission in error, please contact the sender immediately by
replying to
this email and delete the material from all computers.

<jnthn.a...@gmail.com>



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Reply via email to