Like Ben says, if you can get away from using Access do so but if not you could look into something called ODBC-ODBC Bridge that will allow you to connect from a Linux machine to an Access database on an NT machine. ODBC-ODBC Bridge seems to work pretty well from my testing but I don't use it in production. One problem I can see with the postgresql solution is that you might not want all your sensitive information on your webserver. I prefer not to have any direct connection between my webserver and my database servers let alone run them on the same machine. The system I setup at my workplace runs a VB program (which has the advantage of being able to pull data from many different types of databases including Access) nightly to save data to a delimited text file, FTP it to the Linux server and run a PHP script there which loads it into a mySQL database. It's surprisingly robust and it's able to pull only the data you need from various databases and process it prior to uploading. Brady >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 > > > >_______________________________________________ >tclug-list mailing list >tclug-list at mn-linux.org >https://mailman.mn-linux.org/mailman/listinfo/tclug-list ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~ "Since we're going to die anyway we might as well be thinking something really stupid." - Nothing Man (leader of the "Brotherhood of Dada")