2
votes
0answers
102 views

Unable to directly edit DBF files in LibreOffice

I often use QGIS and need to edit DBF files asociated with the shapefile layers. I am used to do it in LibreOffice and it always worked on Windows and I think it also worked in older versions of ...
0
votes
0answers
24 views

Should the spell-checher work with LibreOffice Base

I have been trying to set up a set of simple databases for various projects, that require large text entries. I wanted some thing quick and "lite" so tried Glom but could not find any way of ...
0
votes
0answers
162 views

Libre Office Base List Box

I have 4 tables setup. This is for a course of mine and is an example DBMS. Tables: fields Categories: CategoryID, CategoryName, CategoryDescription Customers: CustomerID, FirstName, ...
1
vote
2answers
3k views

What alternatives to MS Access exist for database management on the Ubuntu platform (LibreOffice Base isn't cutting it) [duplicate]

I have a web-based MySQL database, which is very important. I have used the MySQL Connector to allow me to use an MS Access database to query, and clean up my database, through an ODBC connection. ...
0
votes
1answer
78 views

How can I tie an alert to a LIbra database?

I want to know how to tie an "alert" or notification to a column in a LibreOffice database table. I'm a new Linux user and am working with a LibreOffice database. In the near future I intend to put ...
0
votes
2answers
490 views

How do you use the ROWNUM fuction (or similar) in LibreOffice Base query?

I am trying to help someone who wants to put data into alphabetical order with a row number. I thought I could do a query like this select "name", ROWNUM() as "Row" from "data" order by "name" But ...
7
votes
2answers
16k views

Is it possible to open a Office 2010 Access files?

I have a .accdb file created with Microsoft Office 2010 and I want to know if it is possible to open it with some native Ubuntu application like LibreOffice or OpenOffice, I know LibreOffice has ...
3
votes
4answers
11k views

How can I open .db files?

I've imported a .db file from my android device and I wish to open it using Libreoffice Base or something similarly basic with a simple GUI. How do I achieve this?
2
votes
1answer
2k views

Missing ODBCConfig for SQLite and LibreOffice Base

I have used OpenOffice Base as a front end for SQlite databases, in 10.04 linked via ODBC. I am updating to 12.04, so I loaded LibreOffice Base, looks just like OObase. I have 12.04 on one drive and ...
0
votes
1answer
407 views

How to access MySQL server with user password issued through LibreOffice Base frontend?

When dist-upgrading Ubuntu 11.10 to 12.04 UpdateManager asked to enter a "new" user password for MySQL. I denied 3 times. This asking was put misleadingly. I better should have entered a user password ...
0
votes
1answer
77 views

How obtain error message when exporting data from LibreOffice Base to Calc and freezing occurs?

[Ubuntu 12.04] When exporting large (100 MB) data from a table in LibreOffice 3.5.2.2 Base embedded HSQLDB to a Calc spreadsheet using the procedure outlined in LibreOffice Help, LibreOffice Base and ...
1
vote
2answers
11k views

Get a SQLite3 db in LibreOffice (via ODBC). Using Ubuntu 11.04 (64bit)

I'm stuck with this. I had SQLite working with OpenOffice in the past. But since then i reinstalled my machine and so... Now I can't get it to work. i pretty much followed this guide: ...
2
votes
0answers
217 views

My .odb database spikes the CPU in OpenOffice and LibreOffice [closed]

my database is in .odb format, and it does not work in 9.1, 10.04, 10.10, openoffice OR 11.04 beta libreoffice but works in xp, w7 and fedora 14 The biggest issue i'm facing is that it takes minutes ...