Migrating an Access front end to an SQL back end

  • Is there any tool for migrating an Access front end to an SQL back end? That is, unbinding forms, creating and using pass through queries, connect strings, etc.?

  • Hi sonashish,

    quote:


    Is there any tool for migrating an Access front end to an SQL back end? That is, unbinding forms, creating and using pass through queries, connect strings, etc.?


    AFAIK there is not such a tool.

    Because you can also work with linked SQL Server tables and bound forms in Access, I think the unbinding of a form will be in any case left for you. The rest could be done with such a tool as the Access SQL Upsizing wizard.

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply