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+h...@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
