Re: THANKS! -> Re: Valid MS Access SQL Syntax (Double JOINtedness)

From: Don (someone_at_somewhere.net)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 14:28:39 -0500

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23xiCSDDHFHA.2616@tk2msftngp13.phx.gbl...
> Don wrote:
> > Bob,
> >
> > Thanks for the comments! Your suggestion worked and I am now
> > expanding my knowledge on the topic. As our ultimate goal is to host
> > this on a SQL Server, I have had a non-Access mind set (hence my post
> > to microsoft.public.sqlserver.programming). So much so I did not
> > even think about using the Query Builder!
> >
> > Will the Access syntax work on SQL Server? It would be annoying to
> > have to come back and reconfigure the SQL strings. But I suppose
> > sometimes such is life!
> >
>
> The nested joins should work, but you should consider that a one-to-one
port
> from Access to SQL Server will cause you to fail to take advantage of many
> performance enhancements available in SQL Server.
>
> Bob Barrows.
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Bob,

Further down the road, we will be able to tune the application. It is a
matter of going from a concept exploration and demo phase (under Access) to
a "working" system under SQL Server.

Thanks again for the help!

Don

Relevant Pages