[AccessD] SQL vs Access

Arthur Fuller fuller.artful at gmail.com
Fri Feb 1 12:12:38 CST 2008


I've just sent a post that answers your question. The answer is yes, within
limits as outlined.

Arthur

On Fri, Feb 1, 2008 at 12:55 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

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