Re: [libreoffice-users] Min. skills for Base

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.ames@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.ames@gmail.com>

--
To unsubscribe e-mail to: users+unsubscribe@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