• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 460
  • Last Modified:

SQL Server Express with DAO?

I've written an application in Visual Basic 6, it uses DAO database calls to grab data from an Access 97 backend. The data names are referenced via windows ODBC names.

As the database has significantly grown, I'd like to upgrade the backend to Sql Server Express edition.

Des SQL Server Express 2005 edition support DAO methods? Has anyone ever done a migration like this? Any other tips or suggestions? Thanks.

Just to give an overview of the connection...

-user loads client EXE (VB)
-client creates reference using ODBC name to data recordsets.
-client updates or views data from database using DAO methods.

The client has a builtin reference to MS DAO 2.5/3.5 compatibility library.

1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Yes, you can open SSE databases with DAO. In general you're better off with ADO, however.
blueskies77Author Commented:
Cool thanks. With converting the code to ADO I'd just a sooner keep DAO as the VB code is really huge and there is 1000's of database calls I just dont have the time to do it.
It should run well enough. For upsizing the tables, etc you probably want to use SQL Server Migration Assistant for Access instead of the Upsizing Wizard.

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now