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
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.
You can install MySQL Java connector to use Base as GUI/frontend to MySQL: http://dev.mysql.com/downloads/connector/j/. 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.
Do you have any dumb-guide or step by step guide showing the whole process?
Did you ever get an answer for this?