[AccessD] MSAccess XP to SQL2005 Backend

Robert L. Stewart robert at webedb.com
Thu Jan 3 12:23:52 CST 2008


Also, there is no ADP in Access 2007. So, that would
be an issue with upgrading also.

The Management studio is essentially free with the
express version or as an install of the workstation tools
from the full version.

At 12:00 PM 1/3/2008, you wrote:
>Date: Thu, 3 Jan 2008 10:10:08 -0500
>From: "Arthur Fuller" <fuller.artful at gmail.com>
>Subject: Re: [AccessD] MSAccess XP to SQL2005 Backend
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID:
>         <29f585dd0801030710j4f86c6b8k87f8158ff9afd963 at mail.gmail.com>
>Content-Type: text/plain; charset=ISO-8859-1
>
>Be forewarned that some of the coolest new capabilities in SQL 2005 will be
>off limits to your Access apps, including table UDFs and schemas and Common
>Table Expressions (CTEs). But if you avoid using these, you should be fine.
>
>Arthur
>
>On 1/3/08, Steve Zayko <szayko at secor.com> wrote:
> >
> > Robert/Arthur:
> >
> > Thanks for the insights.  Upgrading Office would seem to be the logical
> > solution.  However, the cost of upgrading 1000 employees from XP to 2007
> > would be a bit high.  The cost of Mgmt Studio for me and a few others
> > would be easily justifiable.  Plus I get a new toy to learn and play
> > with.
> >
> > Thanks again.
> >
> > -Z
> >





More information about the AccessD mailing list