I have not been tracking MS Access system design since version 1.1, but
back then Access did have an external database back-end (server) engine
called Jet. Jet was bundled in with Access, much like Base uses HSQLDB,
but I think it could be used by other front-end clients than Access.
So, the MS Access client-server topology was not that unlike Base.
Base just allows one to get out of the MS Access proprietary "silo" and
allow much more control of the database system.
For the record, I am using MySQL with Base, soon to be switching to
MariaDB. I have not needed to use any macros in my work with Base forms
or reports. I have made it a point to avoid macros because they are
very client-dependent and they would lock me in to a specific client,
much as the MS Access macros in your database are causing you problems
now. I have been able to do some of what you are needing to do with
forms, only I used queries. Many of my forms have list boxes where I
select one of a list of options to be inserted into a database field.
Although I have not used it, there is another type of drop-down listbox
that presents options, but if an option not in the list is needed, the
user may enter that option into the field. I may have misread your
posting, but that may be what you need. I can see that there are times
when macros would be the only answer to a problem, such as with custom
forms, but my recommendation is to avoid them whenever you can.
Girvin Herr
On 05/05/2014 12:28 PM, milica wrote:
Thanks,
Actually, that base in ms access is kind of start point, and needs to be
more developed,so I have to learn LO macros anyway :(
I'm reading the book OpenOffice.org Macros Explained (great book!),
and
making new version in LO but in LO Calc.
Thank you once again :))
On Mon, May 5, 2014 at 7:29 PM, TomD [via Document Foundation Mail
Archive]
<[hidden email] <http://user/SendEmail.jtp?type=node&node=4107732&i=0>>
wrote:
Hi :)
Good point!!
An external database is a really good approach. Many people go for
MySql
or MariaDb (unless using a Mac) but that's owned by Oracle and some
worry
about the future of "free" or "Open Source" under Oracle. Many go for
faster, lighter java back-ends such as Hsqldb as an external but others
worry about the whole java issue.
So Postgresql might well be a good choice. They have put a lot of work
into building a decent connector for Base.
Regards from
Tom :)
On 5 May 2014 15:44, Wolfgang Keller <[hidden email]<
http://user/SendEmail.jtp?type=node&node=4107696&i=0>>
wrote:
I'm new user of LO Base, we are transitioning from MS Access, and I
need to redesign our db from it.
One word of advice based on experience:
Avoid use of the "built in" database.
Use a proper client-server RDBMS. Preferrably PostgreSQL, as it's
reliable and the driver comes with LO.
Otherwise you *will* regret it the day your data has gone to Nirvana.
Sincerely,
Wolfgang
--
To unsubscribe e-mail to: [hidden email]<
http://user/SendEmail.jtp?type=node&node=4107696&i=1>
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
--
To unsubscribe e-mail to: [hidden email]<
http://user/SendEmail.jtp?type=node&node=4107696&i=2>
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:
http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
------------------------------
If you reply to this email, your message will be added to the
discussion
below:
http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107696.html
To unsubscribe from Need help with Base, click here<
.
NAML<
http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
--
To unsubscribe e-mail to: [hidden email]<http://user/SendEmail.jtp?type=node&node=4107732&i=1>
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
------------------------------
If you reply to this email, your message will be added to the discussion
below:
http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107732.html
To unsubscribe from Need help with Base, click
here<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4107400&code=bWlsamtvdmljLm1pbGljYS44M0BnbWFpbC5jb218NDEwNzQwMHwxODIyNjg3NDEz>
.
NAML<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.