Re: What is best Customer DB for a growing company?

MS Access should be fine until your largest table have over 100,000 to 200,000 records, or you have more than 10 concurrent users. Access can connect to Btrieve via ODBC (there are also third party drivers that will connect Access to Btrieve. Access has a file-server database architecture.  With more users or larger number of records, consider a client-server architecture database engine such as MS SQL Server, IBM DB2, Sybase SQL Anywhere or SQL Server, Oracle Server, or Borland Interbase. Good luck. Gene

Ray Smith <ray_at_mediacy.com> wrote in article <347345AD.317C_at_mediacy.com>...
> Hi,
>
> This is for you experienced DB people out there.
>
> If you had to buy database software to keep track of orders, sales,
> customers, and products (say 25,000 customers, 100 products) what would
> you choose? Eventually it should be able to collect data from the web
> too. And the ability to export directly to Solomon 4 with Btrieve would
> be great also.
>
> I have a experience with Access (that's what we use now) but I keep
> hearing that there are better ways.
>
> Any help is GREATLY APPRECIATED!!
>
> Please copy me by email if possible.
>
> TIA!,
>
> Ray
>
Received on Thu Nov 20 1997 - 00:00:00 CST