Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


Am 09.08.2012 18:51, webmaster-Kracked_P_P wrote:
I have one users that only uses Windows due to his need to access a
database he created using MSO 98[?] and now using MSO 2000 or 2003. With
no real Base documentation for me to deal with, I cannot figure out how
to make it work with Base.

So this guy has to deal with a slow computer running XP instead of a
faster/newer computer I can give him running Ubuntu.

Base is the real problem for some.  We need to have good documentation
on how to take an existing Access database and make it work under LO's
Base.  If I could take his database and make it editable and have good
templates for viewing and printing of it, then I could get this guy
using LO.  Corel Draw 11 would be switched to Inkscape as well.  I
switched, with very little issues.  He would do fine there as well.  It
is just his large personal book inventory database, and his hobby
related one as well, that is the stalling point.



Connecting a Base document to some tabular data is the same procedure for csv, dBase, spreadsheets, mail client address books and all kinds of connectable true databases (MySQL, Access, Oracle, ...).

MS Access (database in a single *.mdb file) is a Windows only database because the required drivers are made by MS for Windows only:

File>New>Database...
[X] Connect to existing database
Type: <MS Access>
Point to the *.mdb file
[X] Register database
Save database.

Now you have a backend database which is contained in the *.mdb file and a frontend database which is the *.odb file connected to the *.mdb (see status bar). It shows all the tables. Base needs a primary keys in order to edit a table. Tables without primary key are read-only.

[Tutorial] MS Access and OOo Base:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=25300

[Tutorial] Read-Only in Base:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=83&t=26448



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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

Context


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.