We're currently migrating from Ask to Discourse, read the details here

Ask Your Question

May be possibe a Base file be shared in a home-network and accessed at the same time by several users? [closed]

asked 2014-10-28 05:46:58 +0200

mrmister gravatar image

Hello I'm wondering if may I put a Base file in a shared folder, and make it accessible to several people in my home network. What I need to know is, what would happen if this file has 30 records, let's say, and then I open it and start to introduce records, at the same time, more people at home open it and start to introduce records? What could happen in this scenario? would be possible several people work at the same time with the same file adding records? If this is possible what kind of autonumbering would follow Base for the primary key? I ask this because I am entering a record and perhaps I see 31... but the other user entering also a record at the same time, what would see? also 31? or 32 or what? If someone could help me with this I'd be grateful Cheers

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 18:32:26.663743

1 Answer

Sort by » oldest newest most voted

answered 2014-10-28 08:15:50 +0200

updated 2014-10-28 08:22:00 +0200

I'm 99.999% sure you can't do that, given the file is a ZIP with XML and a HSQLDB file in, essentially being even worse thing than SQLite for multiple users. Maybe if only 1 person ever writes and the rest read, but the data still could be messed up or even corrupted.

edit flag offensive delete link more


You can install MySQL Java connector to use Base as GUI/frontend to MySQL: http://dev.mysql.com/downloads/connec... . I recommend the platform-independent cuz you can drop that JAR anywhere and point LO to it, regardless of platform. Although the connector version is so old, it's no problem since the protocol haven't changed.

rautamiekka gravatar imagerautamiekka ( 2014-10-28 12:45:34 +0200 )edit

Do you have any dumb-guide or step by step guide showing the whole process?

mrmister gravatar imagemrmister ( 2014-10-29 10:17:15 +0200 )edit

Did you ever get an answer for this?

tfallin gravatar imagetfallin ( 2017-01-24 01:59:25 +0200 )edit

Question Tools



Asked: 2014-10-28 05:46:58 +0200

Seen: 389 times

Last updated: Oct 28 '14