Choice of database

[Douglas Bates]

I would like to consolidate some of the data in our office into a
database.  Our office staff uses Windows NT with the usual MS Office
tools.  I see they have MS Access available on a menu but I have no
experience with it.  From the Linux side I would prefer to use an
SQL-aware relational database that supports access through perl DBI or
JDBC.

Can I expect to run a relational database that will support access
from our researchers' Linux systems and from the NT systems used by
the office staff?  I think I would prefer to run the server
(postgresql?) on the Linux system.

Is MS Access the interface that I should expect the office staff to
use?  That is, is it a client that can allow access to an ODBC server?

Please reply with a copy to me.  I don't regularly read debian-user
(too much traffic).
-- 
Douglas Bates[EMAIL PROTECTED]
Statistics Department608/262-2598
University of Wisconsin - Madisonhttp://www.stat.wisc.edu/~bates/

Re: Choice of database

[aqy6633]

 I would like to consolidate some of the data in our office into a
 database.  Our office staff uses Windows NT with the usual MS Office
 tools.  I see they have MS Access available on a menu but I have no
 experience with it.  From the Linux side I would prefer to use an
 SQL-aware relational database that supports access through perl DBI or
 JDBC.

Postgresql is accessable via both JDBC and ODBC. Which makes it possible to
link tables on the server to local ones in MSAccess. You just need to
download Postgres ODBC driver for windows. I tried that once and it worked.

Alex Y.
-- 
   _ 
 _( )_
( (o___   +---+
 |  _ 7   |Alexander Yukhimets|
  \()|   http://pages.nyu.edu/~aqy6633/  |
  / \ \   +---+