[AccessD] SQL vs Access

I have a similar project being considered.

I have done a few projects with AccessXP ADP and SQL2K.  Is there a 
free/lite version of SQL2K?  If so, will a database created in SQL2K 
work seamlessly in the lite version?

If there is not, I also have SQL2005.  Will a database created in 
this be able to be used seamlessly with SQL Express.

Can AccessXP ADP's work with SQL2005?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand

At 2/02/2008, you wrote:
>Rocky,
>
>As Susan wrote, SQL Express is a viable option. The IT department's point
>about backup and restore is well-taken, too. Since they already have a
>backup strategy in place, adding one more DB to it should be trivial. Then
>you (and they) can forget about it, except for the verification step, which
>they probably have automated already for their other databases.
>
>Were I you, I would acquiesce immediately on this one. You have nothing to
>lose but credibility if you fight them, and an opportunity to work with SQL
>Express or SQL Server.
>
>Given this path, you should be concerned about which version and format
>you'll be using. IMO the best combination is A2K or A2K3 using ADP format to
>talk to a SQL 2000 db. If you try talking to a SQL 2005 db from either of
>those Access versions, it works, sort of, but you miss a lot of the goodies
>due to the internal restructuring of the SQL db format. OTOH if you're going
>to use A2K7 then it's a good fit with SQL 2005.
>
>hth,
>Arthur
>
>On Fri, Feb 1, 2008 at 12:03 PM, Susan Harkins <ssharkins at gmail.com> wrote:
>
> > You might find SQL Server Express easier to work with than Access -- they
> > might be willing to make that compromise with you.
> >
> > Susan  H.
> >
> >
> > > Hi Rocky
> > >
> > > As he has several running servers and a proven backup scheme, he has a
> > > valid point.