Solveig L Haugland wrote:
Hi,
In Base, one can easily create data entry forms. However, to allow
users such as data entry clerks to use the forms, they would need to
open the .odb file and then double-click the name of the form.
Is there a simpler way to allow users to access the form? Creating a
copy doesn't retain the ability to enter data.
Usually, a macro is used that is called when the database is open. I
have seen a solution for this a few times, but have not paid attention
to it. I think that Andrew Jensen may have penned the solution. He
authored this:
http://www.oooforum.org/forum/viewtopic.phtml?t=25060
Also, regardless of the mode of access, can two users use a form to
enter data in a native Base database at the same time?
<ENTER GUESS MODE>
Never tried it, but it would likely be related to how the connection is
open. My guess is that it MUST be opened using getIsolatedConnection()
so that the connection is not shared. In your case, however, the problem
is probably not that two connections are in the same space, but that TWO
people are trying to access the same BASE document. If this uses
HSQLDB, then the data is stored in the document itself. I think that
this can NOT be shared any more than two people editing the same text
document. You might get away with it if the backend database is NOT
stored in the same document, such as a MySQL database backend.
I'm using 2.2.
Thanks,
Solveig
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
