Hi,

hopefully the subject says it all. Is their book still the best
reference on working with Access as a FE to SQL Server? Or is there an
update coming out soon? Any other books anybody knows of (besides ADH,
which are always great if you have enough experience to understand
them!) that are really good for developing for Access and SQL Server?

Sorry if this has been asked to death - had a look, but didn't see any
other suggestions.

Thanks,

Pieter

"(E-Mail Removed)" <(E-Mail Removed)> wrote:

>hopefully the subject says it all. Is their book still the best
>reference on working with Access as a FE to SQL Server? Or is there an
>update coming out soon?

I suspect it is. No idea on an update but I strongly suspect the
basics won't have changed.

>Any other books anybody knows of (besides ADH,
>which are always great if you have enough experience to understand
>them!) that are really good for developing for Access and SQL Server?

I don't recall the other books and I'm not at home right now so I
can't flip through them. I don't think there are any newer books on
this topic.

>Sorry if this has been asked to death - had a look, but didn't see any
>other suggestions.

It hasn't been asked to death.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Tony Toews wrote:
> "(E-Mail Removed)" <(E-Mail Removed)> wrote:
>
> >hopefully the subject says it all. Is their book still the best
> >reference on working with Access as a FE to SQL Server? Or is there an
> >update coming out soon?
>
> I suspect it is. No idea on an update but I strongly suspect the
> basics won't have changed.
>
> >Any other books anybody knows of (besides ADH,
> >which are always great if you have enough experience to understand
> >them!) that are really good for developing for Access and SQL Server?
>
> I don't recall the other books and I'm not at home right now so I
> can't flip through them. I don't think there are any newer books on
> this topic.
>
> >Sorry if this has been asked to death - had a look, but didn't see any
> >other suggestions.
>
> It hasn't been asked to death.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm

Thanks Tony. any other books on the subject that are really good?
Also, along the same lines, anybody know a good book on stored
procedures? I'm just basically clueless on SQL Server. Thanks!

Okay, getting over a blonde moment. Does having the CLR built into SQL
Server 2005 radically change development process/tools? Thanks!

Pieter

"(E-Mail Removed)" <(E-Mail Removed)> wrote:

>Okay, getting over a blonde moment. Does having the CLR built into SQL
>Server 2005 radically change development process/tools? Thanks!

Good point. It could yes. Some things that I had to do in functions
called by Access queries could now be done in CLR. However calling
functions in queries was something I avoided anyhow.

However this isn't all that relevant to a book dealing with Access and
SQL. You could gain pretty much everything you need with a book
dealing on the CLR and SQL Server 2005.

Or to put it another way you would not waste your money by purchasing
two books, one about Access and SQL Server and another on SQL Server
2005 only.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Tony Toews <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> Or to put it another way you would not waste your money by
> purchasing two books, one about Access and SQL Server and another
> on SQL Server 2005 only.

And the Chipmen/Baron book is really one of the best I've ever
purchased. It really is quite brilliant in its targeting to us
experienced Access developers.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/