[AccessD] SQL 2005 with A2007 vs A2003 (was: SQL vs Access)

Dan Waters dwaters at usinternet.com
Fri Feb 1 11:41:30 CST 2008


Arthur,

I am soon going to convert all my systems from A2003 FE/BE to A2003 FE / SQL
Express 2005 BE.

But your email says, "It works, sort of."  Could you elaborate on this?
You've got me nervous!

Thanks,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, February 01, 2008 11:14 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SQL vs Access

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.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list