Access DB

[Mark Leong]

Anybody knows how to create Access DB using SO 5.2?
I can use it to access and modify mdb files but cannot seem to create them.

[Floyd Jones]

Howdy Mark -
You can't actually create Access databases with SO. You can, as you mentioned, access and modify them in SO. That's the deal. If you want to create relational databases in SO, the Adabas D format is what you'd use. If you want to create single, non-relational tables, use the dBase format.
------------------
author of:
StarOffice Companion
Standard CYA*******************************
All responses to questions posed in this News Group are given on an
"as is" basis. We believe the solutions or explanations given here are
correct, but do not guaranty that responses will be complete, without
error and/or work for all platforms and system configurations.

[Mark Leong]

Actually that's what I thought. Just want to be sure.
Is there a way I could access Adabas db using JDBC? If yes, where do I get the drivers and how to specify the DBUrl and driver?

[Floyd Jones]

Mark -
My expertise with Adabas D stops at creating them in SO and setting up relations between tables. I don't know how you'd access them from an outside app. Sorry I can't be more help.
------------------
author of:
StarOffice Companion
Standard CYA*******************************
All responses to questions posed in this News Group are given on an
"as is" basis. We believe the solutions or explanations given here are
correct, but do not guaranty that responses will be complete, without
error and/or work for all platforms and system configurations.

[Anonymous]

These links are to companies that have JDBC drivers specific to Adabas:
http://www.i-kinetics.com
http://www.informationbuilders.com
http://www.adabas.com
http://www.sas.com
http://www.trifox.com
I guess I would recommend using the driver written by Software AG since they are the Adabase guys. Anyway, this link details the use of their driver, including the connection url that you will need.
[This message has been edited by Bodie Minster (edited December 21, 2000).]

[tony hutcheson]

I know this was posted a long time ago, but I wanted to respond because it helped answer a question I had.
I tried "creating" a database with Star Office and was frustrated rather quickly. The help files were not very clear from the start that SO does not have the stuff to create a database, only to connect to them (unless you install Adabas D). I will try either DB2 or Adabas and then connect it to SO.
Star Office has not disappointed, just frustrated a couple of times. Knowing is more than half the battle.

[Solveig Laura Haugland]

Originally posted by tony hutcheson:
I know this was posted a long time ago, but I wanted to respond because it helped answer a question I had.
I tried "creating" a database with Star Office and was frustrated rather quickly. The help files were not very clear from the start that SO does not have the stuff to create a database, only to connect to them (unless you install Adabas D). I will try either DB2 or Adabas and then connect it to SO.
Star Office has not disappointed, just frustrated a couple of times. Knowing is more than half the battle.

Hi Tony,
You definitely can create databases using StarOffice. See "Creating Databases" on page 992 of "StarOffice Companion" for more info. You can create dBase (nonrelational)and Adabas D databases. And I think can add a table to Access 97 databases. It's definitely not the most intuitive approach, but it's possible.
I think you can also do drag-and-drop to turn a spreadsheet into a dBase database--that's the easiest way to create a database. (Page 1004.)
Hope this works,
Solveig

------------------
author of:
StarOffice Companion