Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||No Way to Share Database Applications and have multiple people using the same application at once|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||drewjensen.inbox, issues, mechtilde, meenu.ibs|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description vreid47362 2005-02-12 13:40:25 UTC
There does not appear to be any way to share a database application created with OpenOffice Base. For example, with Microsoft Access and Lotus Approach, a database application can be shared and used by multiple users at one time by simply having each user open the database document. OpenOffice Base appears to lack this ability. This severe limitation on the usability of the application. Please fix this problem.
Comment 1 marc.neumann 2005-02-15 11:18:02 UTC
Hi, I reassign this issue to User Experience for evaluating. Bye Marc
Comment 2 jsalazar 2007-10-12 19:52:38 UTC
It would be very useful if Base could lock by register instead of by database. The single-user database ends up being used the same as a plain spreadsheet.
Comment 3 Mechtilde 2007-10-13 09:56:49 UTC
You can use Base with many database management systems (DBMS). Many of them can be shared by users. How the access is locked depends on the used DBMS. Only if you use OpenOffice.org with the internal HSQL DB you can't share it.
Comment 4 vreid47362 2007-10-13 16:19:37 UTC
I think most computing professionals realize that you can use Base with lots of other DBMS systems for multi-user applications. That, however, is not the point. The point is that most Windows based office workers do not have the technical capabilities or time to install mysql or firebird on their windows workstation or departmental server, and they don't have the time or technical capabilities to set up a dedicated *nix box to do this either. These people don't have the time to manage these things, and most don't even know what sql is or for what to use it. These workers, which are the biggest potential markets for OpenOffice need a simple out-of-the-box multi-user database. MS Access offers this capability, Corel Wordperfect offfice offers this capability, Lotus Approach offered this capability, Ability office offers this capability, and even the older versions of StarOffice offered this capability (it may still offer this, I'm not sure). The fact of the matter is that many many small and medium businesses rely on these types of shared user created databases to get work done, even though, ideally, these things would be created by dedicated sysadmins on a dedicated server with a dedicated dbms. Most small and medium businesses don't have this kind of knowledgeable database/system administrator available. So, they rely on the office user that's "good with computers" to do these types of things. I'd estimate that, 90% of the time, this person doesn't have a clue about how to set up a dedicated database service on either his/her computer or on a server. So, my point is that the ability to share OpenOffice's integrated database type and make it multi-user is essential for making OpenOffice a viable replacement to MS Office and others in the majority of small to medium businesses.
Comment 5 drewjensen.inbox 2007-10-13 16:29:42 UTC
@Mechtilda True you can setup a server, but even then that does not address shared forms, reports and queries in a Base file. StarBase 8, downloaded from Google, offers the option to create an AdaBase database, but still does not address the issue of these shared documents / components held within the Base file.
Comment 6 drewjensen.inbox 2007-10-13 17:02:49 UTC
Changing this from an enhancement to a feature, as this would require more then one issue, IMO. There is the issue of user account maintenance, issues with scripting security mechanism, shared versus private documents / components within a Base file - should they and/or how would they, he handled: to name a few.
Comment 8 andreluizmtg 2009-12-08 17:12:32 UTC
Comment from atjensen Sat Oct 13 15:29:42 +0000 2007 says it all. 99% of users don't have enough knowledge to use sql or similar. Providing a multiuser database is essential to make openoffice more popular. Till there, I will have to go back to Microsoft Access and uninstall openoffice.