Jim Lawrence (AccessD)
accessd at shaw.ca
Thu Jul 1 22:20:13 CDT 2004
Hi David: There are FEs that are designed to handle more clients like web based ones. There is a trade off as they are slower and do not have as many features. The new vb.net have the capability to be the FE, data web connection and sever side database interface. I have not actually created an applications with the product yet but if it lives up to current billing... An Access FE will work with hundreds of customers. The main issue is what type of BE do you have. It would have to be a SQL DB; SQL2000, Oracle, MySQL etc. on a server or severs of significant power, depending on the application. That volume of data is far beyond an Access MDB. HTH Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of David Emerson Sent: Thursday, July 01, 2004 4:48 PM To: dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer] Alternative Front Ends Group, A company I am contracting to what to know if there are any "higher" alternatives to Access adp's. They are concerned that Access may not be powerful enough to handle databases with monthly accounts for say 200,000 customers. Any comments? Regards David Emerson Dalyn Software Ltd 25 Cunliffe St, Churton Park Wellington, New Zealand Ph/Fax (04) 478-7456 Mobile 027-280-9348 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com