Text 59917, 75 rader
Skriven 2010-02-09 10:00:48 av Alan Zisman (1:123/789.0)
  Kommentar till text 59913 av Bo Simonsen (2:236/100.0)
Ärende: OpenOffice database...
==============================
On 09-02-10 7:32 AM, Bo Simonsen -> Alan Zisman wrote:
 BS>>> Isn't it ODBC compatible?

 BS>>> Then you should be able to access any kind of database. On
 BS>>> Linux/Unix-clones
 BS>>> it might use unixODBC which doesn't allow MS-Access access afaik.
 BS>>> However on the Windows platform it should be able to use access
 AZ>> because
 BS>>> of Windows ODBC.

 BS>>> But I am not sure at all..

 AZ>> If Access is being used as a pretty front-end to a large networked
 AZ>> database, then you may be correct, with OO.o's database being able to
 AZ>> access the same underlying data. But if Access is being used to create
 AZ>> database files from scratch, they are saved in a proprietary file
 AZ>> format...

 BS> Well who would use Access for a large networked database?! :-) I remember
 BS> that even shops on the internet were based on Access in the late 90's.
 BS> So some had done this, but I also think that they did regret it.

 BS> You can get SQL databases for free (MySQL, PostgreSQL, Firebird), some of
 BS> these can run on Windows, so why not use a database server for large
 BS> setups?

 BS> To get back to the topic, I am quite sure that Microsoft provide a ODBC
 BS> driver on Windows, however ODBC does not do much more than SQL as far as I
 BS> remember, and Access might not be completely standard compliant regarding
 BS> SQL because it offers features which cannot be made with SQL (I am
actually
 BS> not sure about this claim).

 BS> There is a lot of toturials on ODBC and Access on the web, just search for
 BS> "Microsoft Access ODBC" on google. :)

 BS> Another problem in this situation with OpenOffice would be the OpenOffice
 BS> ODBC support. I have not any experience with that, so I don't really know
 BS> how well it works.

I think we need to back up several steps and think about how databases and
personal computers evolved over the past 25-30 years... and then  go back to
the original poster's question and intent...

While there have been large corporate/network databases for probably as long as
there have been large corporate networks, when personal computers evolved, the
original personal productivity applications were word processors, spreadsheets,
and databases - all meaning software for individuals to create documents.

Along with early generation word processors like WordStar (and a bit later
WordPerfect) and spreadsheets like Visicalc (and a bit later Lotus 1-2-3) there
were database applications like dBase III (and a bit later FoxPro, etc). They
were commonly used to produce databases for home and small business use.

When Windows became a popular user environment, Microsoft and others released
personal productivity applications for Windows: MS Word, MS Excel, and MS
Access.

While word processor and (to a lesser degree) spreadsheet documents continue to
be created by home and small business users, to a large extent, this sort of
database use has disappeared... these users most often use spreadsheets as
personal database products, which works - sort of. The word 'database' is used,
almost exclusively, to refer to large corporate-network collections of
information.

So the question is what did the original poster intend? Using OO.o's database
for a small-scale personal project? Or to work with a large ODBC or SQL-based
database?

I don't know. Do you? But until we know the context of the original question,
we will just be talking past one another, and probably not really answering his
question!

--- Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.7) Gecko/20
 * Origin: Fidonet Via Newsreader - http://www.easternstar.info (1:123/789.0)