Ask Your Question

LO Base 5 : How to create password protected / encrypted database? [closed]

asked 2016-03-30 06:44:10 +0200

Adnan gravatar image

updated 2020-09-02 15:06:56 +0200

Alex Kemp gravatar image

I am a school teacher. We have a chapter about database in our ICT course. I am planning to teach kids LibreOffice Base for the fundamental idea of the database.

I found out that there is no "straight" way in LOBase5 for teaching the database encryption. And to my experience, the alternative ways are much complicated for the kids to understand.

Can anyone please suggest me an easy way to introduce database encryption using LOBase5?

Thanks in advance!

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-02 15:07:17.371133

1 Answer

Sort by » oldest newest most voted

answered 2016-03-30 07:38:11 +0200

Ratslinger gravatar image

WOW! A tough question when dealing kids. First, thanks for your efforts to go the extra step.

However, it's not really practical when just dealing with LibreOffice or other Office packages. Base is not a database but a front end to a database. The database that comes with Base is a stripped down version of HSQLDB (HyperSQL Database). This version does not allow for password protection or encryption. You can get and install (at no cost) a full version of HSQLDB or other databases (MySQL, PostgreSQL, etc) but that might entail quite a bit of work installing and setting up just for what you want to accomplish. In fact, just to be clear, for what you are talking about you don't even need Base. Just a database. But again, maybe more trouble than the reward.

Encryption would be tough to demonstrate anyway. It's more of a substitution which is difficult to actually demonstrate. Simple encryption would be like Morse code - configuration of dots & dashes which actually mean something else. Password protection for a database is just like signing on to an e-mail account or opening a door with a key.

I think it may be easier to use examples than an actual demonstration for encryption (decoder ring or substitution chart where Q = T etc). Sorry, but I can't think of an easy way.

edit flag offensive delete link more


Thanks for the help ... anyway! :(

Adnan gravatar imageAdnan ( 2016-04-02 07:20:03 +0200 )edit

Question Tools



Asked: 2016-03-30 06:44:10 +0200

Seen: 1,111 times

Last updated: Mar 30 '16