Issue 42614 - No Way to Share Database Applications and have multiple people using the same application at once
Summary: No Way to Share Database Applications and have multiple people using the same...
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m77
Hardware: PC Windows 2000
: P3 Trivial with 17 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-02-12 13:40 UTC by vreid47362
Modified: 2013-02-07 22:38 UTC (History)
4 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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

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 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

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 7 dgsarnow 2008-08-13 10:01:40 UTC
*** Issue 42614 has been confirmed by votes. ***
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.