Ask Your Question
0

multiple user stand alone form using base

asked 2020-04-29 05:56:26 +0100

arzie2000 gravatar image

I have a LO Base file with tables/queries. I created a standalone form (.odt) that is connected to the Base file. I use the standalone form to input data to the Base file, it's all working fine. No problem there. I have tried opening two instances of standalone form on my desktop, tried inputting data on both forms. No problem there, the primary keys of each form still auto-increments depending who saved first. Now, my question, will there be any potential problem when the standalone forms are opened in two (or more) different computers? (all computers have the same LO version installed) What will be the limitations on this type of setup? (e.g. appending, deleting or adding records). Or any recommendation on how to make this work. Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-04-29 06:07:34 +0100

Ratslinger gravatar image

Hello,

Any time you are going to access a database with more than one user, you need to use a database server. The server provides functionality such as record locking so there are no problems with more than one person accessing/updating the same information.

There are many freeware DB servers such as HSQLDB, Firebird, MySQL, PostgreSQL and many more. Documentation and/or software is available with an internet search. This documentation typically includes installation and usage.

edit flag offensive delete link more

Comments

Thanks for the reply! Is the embedded HSQLDB on the liberoffice base a database server? (asked when creating a new database) or i need a separate one?

arzie2000 gravatar imagearzie2000 ( 2020-04-29 07:25:56 +0100 )edit

Hello,

The HSQLDB embedded which comes with LO is very old - v1.8.x

If you want to use HSQLDB see his site -> http://hsqldb.org/

Ratslinger gravatar imageRatslinger ( 2020-04-29 18:25:16 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-04-29 05:56:26 +0100

Seen: 74 times

Last updated: Apr 29 '20