spd
Nov 21st, 2000, 01:47 PM
I have a VB6.0 project which is a front end to an Access 97 database. I use DAO 3.51 and need to port the application to a MS SQL database. I have the following questions.
1. What software is required to get started? Do I need to purchase MS SQL or do I order Visual Studio. Currently all I have is VB 6.0 Pro.
2. Can I use DAO to access the database?
3. The project uses many seeks to find a particular record in a recordset instead of a query. Do the SQL databases support a Seek statement instead of an SQL query to find a particular record?
Any suggestions or recommended getting started books on SQL would be appreciated.
1. What software is required to get started? Do I need to purchase MS SQL or do I order Visual Studio. Currently all I have is VB 6.0 Pro.
2. Can I use DAO to access the database?
3. The project uses many seeks to find a particular record in a recordset instead of a query. Do the SQL databases support a Seek statement instead of an SQL query to find a particular record?
Any suggestions or recommended getting started books on SQL would be appreciated.