SQL Server Express with DAO?

Posted on 2009-04-27
Last Modified: 2013-11-29
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.

Question by:blueskies77
    LVL 84
    Yes, you can open SSE databases with DAO. In general you're better off with ADO, however.
    LVL 1

    Author Comment

    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.
    LVL 18

    Accepted Solution

    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now