Super User Stack Exchange
Super User Stack Exchange

Questions tagged [openoffice-base]

OpenOffice.org's database component, building on the HSQLDB database engine.

OpenOffice.org's database component, building on the HSQLDB database engine. Allows accessing other database servers (e.g. postgreSQL) using ODBC/JDBC, making SQL database engines available for OpenOffice.org users.

Useful external links:

15 questions
5
votes
1 answer

How can I open a .mdb with a password in OpenOffice?

I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open this file using Base?
rtf
  • 12,408
  • 14
  • 48
  • 88
4
votes
1 answer

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access would be out of the question. (or OOBase/MySQL…
user332893
3
votes
1 answer

Populate foreign key using combo/dropdown on form

I'd like to populate a foreign key field in one table using a combobox/dropdown where the values the user sees are not the IDs but a description field from the foreign table. Consider the following setup: create table people ( id int identity…
LondonRob
  • 406
  • 6
  • 24
2
votes
0 answers

How do I combine data in two tables in LibreOffice?

I have a spreadsheet with two sheets. SheetA has Customer number and location, and SheetB has Order number, Customer number. How do I combine the data so that one sheet has Order number and location? Every column of SheetA is unique, but SheetB may…
user2430974
  • 21
  • 3
2
votes
1 answer

OpenOffice Base locked

I ran into an issue with my open office base file. It appears to be locked (I have file.odb and file.odb.lck). Now I can open the base file, but as soon as I select Tables it crashes on me and when I open any of the Reports, it crashes on me. How…
George
  • 314
  • 1
  • 3
  • 19
2
votes
2 answers

Database access through odbc driver and excel

Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file? The program I am accessing data only allows an ODBC connection in. Not sure what database it is.
Daniel
  • 1,425
  • 6
  • 24
  • 41
2
votes
2 answers

How do I use address data in Calc to populate labels in Writer in the OpenOffice.org suite?

I have a list of mailing addresses in a calc spreadsheet - one column per line in the address. I want to print them out on a sheet of labels. When I open a new labels document, there doesn't appear to be an option to set the source of the label…
Erick Robertson
  • 698
  • 1
  • 13
  • 25
1
vote
2 answers

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different flavors of SQL. What I'm significantly hazier on…
HamComa
  • 145
  • 1
  • 4
1
vote
1 answer

Database workflow advice?

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I then need to modify a couple of columns and then…
Pete Q
  • 145
  • 4
1
vote
1 answer

Forms are Read-Only in Open Office Base

I'm in Open Office Base and I want to add records to an existing table/form, but it says read-only. I've already checked the Properties How can I add new records?
Robyn
  • 11
  • 2
0
votes
1 answer

OpenOffice showing syntax eror

Here's what I have so far: SELECT DISTINCT Min("gpa"."current_gpa"), "students"."lastname", "students"."firstname" FROM "students", "gpa" WHERE "students"."id" = "gpa"."id" HAVING ((…
user60839
0
votes
1 answer

Split sheet by rule (filter) in Open Office

I want to split a large sheet. I have different products and for each of them I would like a new file. Is it possible to split the sheet by some rule? P.S. I am new in here, so if my question is somehow not appropriate, just tell me.
Oriesok Vlassky
  • 101
0
votes
1 answer

Access MS SQL server from CentOS (OpenOffice calc)

I installed FreeTDS in CentOS 6 and I can connect from php to remote MS SQL server. However I cannot set up odbc connection so that it shows in list of ODBC connections in OpenOffice apps. If my server is called [10.0.0.11\myinstance] in…
Milan
  • 195
  • 1
  • 2
  • 9
0
votes
1 answer

Displaying OpenOffice Base data in Excel

Is this possible? I assume I need an ODBC driver or other recognised from Excel/Query to access Base.
Jeff
  • 1
0
votes
1 answer

Add items to combo box in edit mode Openoffice Base

I am trying to add a couple of options to a combobox in openoffice base. The combobox will only ever have two options that can be selected so it's rediculous to have a table for specifying the items in the list. How do I add the options to the…
Azztech Wolf
  • 11
  • 1