Jim Hodgers wrote: ---
I wrote a database for a local non-profit organization using an Access DB. They would like to put it on the Web. Since the local ISP uses Linux I
Does anyone on this list know of a DB App under Linux that would allow querying and maintaining an Access Db over the Web from Linux?
Hi Jim, there are Databases available for Linux which have a Web-Interface ! That means, you don't have to write something in 'mesopotamien' language etc. - you just put the requests into HTML, that's it on the WWW side. On the input side, where you want to feed the stuff into the web database, you have to find a solution of exporting the content of the AccessDB and transfer it into the webDB. Prof. Databases running on Linux, costing some money, but have support and have something to be accessed from MS-Windows, are: LNX, Adabas, Empress, etc. many of them have a web interface, some an ODBC-interface. To use a Database for free can be much more work and trouble, if you don't have already experience with that. I dunno how much data you want to feed in the beginning and how much data it will be periodically. Your strategy depends somewhat on such issues. 1. Maybe you first want to have a Linux machine beside the Windows machine to get familiar with the ness. procedures. Then you can connect this Linux box with the Server at the ISP over the Internet and transfer data 1:1 using web interface. OR: 2. You write an Access-Basic Script to export data from AccessDB over TCP/IP while connecting to the target Linux box. First in one room, later over Internet. (Hopefully MS-Access Basic supports TCP/IP...) All these procedures you can write and test in your office - the difference later is just to go over the Internet (and speed of course). After you got familiar with the technics, it's not that difficult. Look on the SuSE site for more information on Databases. <A HREF="http://www.suse.com/"><A HREF="http://www.suse.com/</A">http://www.suse.com/</A</A>> <A HREF="http://www.suse.de/"><A HREF="http://www.suse.de/</A">http://www.suse.de/</A</A>> My personal choice was LNX, because: - Web interface in HTML tags ! - C interface for fast data input (feed) - ODBC interfaces for Windows 3.1 / 95 / NT - ODBC interface for Linux/Unix - Java interface - Python interface (now build in) - ESQL/C interface - ANSI SQL - reasonable prize (much for the money) - more... Additionally take a look at MySQL. Greetings by Lu -- Ludwig Richter CGI consult <A HREF="http://www.cgicon.com/"><A HREF="http://www.cgicon.com/</A">http://www.cgicon.com/</A</A>> Lu@cgicon.com With Acknowledge: richter@cgicon.com _________________________________________________________ Sent with Netscape Communicator 4.04 on Caldera OpenLinux -- To get out of this list, please send email to majordomo@suse.com with this text in its body: unsubscribe suse-linux-e