I would like to replace the ACCESS with SQL Server 2000 enterprise edition. But I have the following problems:
1. While installing SQL should I install as Server or Client.
2. How to connect the SQL with VB 6 for saving,retrieving, modifying data using ADODB connectivity.
Pl help me in detail.