DAO mdb to SQL Server Express?

I have a commercial product built with VB6 that has an mdb backend via
DAO and I am happy with it.

There is a point with high usage among some clients where I will need
to make an upgrade to something like SQL server Express in about a
year's time.

MS are pushing this SQL server Express thing along with VB Express. I
don't particularly want to get into the VB express thing but I wonder if
any one here has ported DAO code to SQL server express.

Comments please...

On Wed, 17 Jan 2007 22:52:13 +0000, Bernie wrote:

¤ I have a commercial product built with VB6 that has an mdb backend via
¤ DAO and I am happy with it.
¤
¤ There is a point with high usage among some clients where I will need
¤ to make an upgrade to something like SQL server Express in about a
¤ year's time.
¤
¤ MS are pushing this SQL server Express thing along with VB Express. I
¤ don't particularly want to get into the VB express thing but I wonder if
¤ any one here has ported DAO code to SQL server express.
¤
¤ Comments please...

You would have to use the SQL Native Client ODBC driver if you are using DAO. This would involve
either creating linked ODBC tables to an Access database or by using the ODBC mechanism directly via
DAO code. ADO would probably be better suited for this (with OLEDB) since it wasn't designed to
support a specific database type as DAO was.

You can find connection string examples at the following link:

http://www.connectionstrings.com/?carrier=sqlserver2005


Paul
~~~~
Microsoft MVP (Visual Basic)