-
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.
-
look in
Start->Settings->Control Panel->ODBC->Drivers
you probably want to open with an ODBC connection
http://www.vbexplorer.com/vb_feature...er_ADO_DAO.asp
