yes, you can load the data into a postgresql relational database, and then
install a postgresql ODBC driver on your windows client workstations. in
MS access you can select the linux server as an ODBC source, and run your
application that way. (you will have to export your access database to
CVS, and load it into postgresql of course) then you can begin writing
PHP, perl, or whatever web applications to use the postgresql backend.
it's not a trivial process, but it's the best way to do any kind of data
storage. even micrsoft recomends that access NOT be used for business
critical data storage. where as postgresql SQL server can easily handle
tens of thousands of transactions a day, on minimal hardware.
Thank You,
Ben Kochie (ben at nerp.net)
"Unix is user friendly, Its just picky about its friends."
On Fri, 23 Mar 2001, Heather Wagamon wrote:
> We have a Linux web server. I would like to write a database-driven web
> application that uses an MSAccess database that we're already using for
> other applications. Is there a way to put an Access database on a Linux
> server and have it accessable from the web and from our office network?
>
> Thanks-
> Heather
> _______________________________________________
> tclug-list mailing list
> tclug-list at mn-linux.org
> https://mailman.mn-linux.org/mailman/listinfo/tclug-list
>