Client/Server type question

 hello,

 We are trying to build an client/server database setup with the following requirements:

1. Server database about 1 GBytes.
2. On the client side, people having PC and Windows, connecting to the server over modem.
3. Client should be able to download queried information.
4. Server having some kind of auditing to tell, who logged on, how long and also some statistics about amount of information downloaded.

 One solution I can think of is having Oracle running on a 486/66 with SCO UNIX. Clients can log into server using kermit etc. and run queries on the server. Disadv. of this would be 1) no GUI interface 2) Oracle costs lots of money when talking about multi-user licenses.

Q) For GUI interface can we have an MS-ACCESS front-end, with SQL*NET and

   TCP/IP combination connecting over modem line to a Oracle server running    on an 486/66 with SCO UNIX.

Q) Is it possible to have MS-ACCESS at both the client and server end with

   some kind of telecommunication software handling the modem connection    between them.

 Two of the major factors we are looking for is cost and GUI client interface. Speed is not a biggy.

 I would greatly appreciate any response from people who had any previous experience setting up such a system or a pointer in the right direction.

 We are not an MS-ACCESS or Oracle fan, any other alternate cost effective method is also welcome.

 Thanks in advance.

 Murali Manickam
 manickam_at_eemips.tamu.edu
 raja_at_hawk.tamu.edu
 rajasaheb_at_tamu.edu Received on Fri Mar 25 1994 - 00:20:26 CET