i'd mainly reccomend books online
and maybe having a 2nd instance of SQL 2005 Developers' edition.. so
you can use the 'Database Tuning Advisor' against the (production) SQL
2000 instance.
i have had _SOME_ problems with that setup; but altogether it's a great
tool for tuning SQL 2000.. I had a half dozen DBAs that had no problem
with it; I just know that it does a better job of creating indexes and
statistics than 2000 does... I'd just make sure you take backups of
the database before using 2005 DTA in a production environment of
course.
other books on ADP? I haven't seen very many books that go into enough
details about ADP.. i think that MS press has an ADP book circa 2003
that is a good choice.
i'd of course check out
www.mvps.org/access that is a good site.
when it comes to deploying the runtime or anything; the
www.accessvba.com site was the best; but i think that it's gone now..
maybe
www.archive.org can show you some good threads from that site??
there was definitely some decent ADP threads there; but the runtime /
deployment information on that site was 2nd to none.. I will miss that
site a lot.
other books; I've read a lot of them-- the 'Professional SQL Sever
development using Access 2000' had some good points.. but it's not
updated for Access 2002/2003; so it's kindof a waste.. that one was
'wrox press' it was written; I want to say buy a gentelman named
'David' i can't remember his real name though.
and then of course; usenet is a decent resource.. but a lot of the
people that you find here are mis-informed when it comes to ADP.
i think that ADP is the most revolutionary product that Microsoft has
ever released.
it kinda amazes me; i've seen a lot of companies using it recently.. I
just would tend to ignore people that are pro-mdb.
I think that MDB is 10 years obsolete.
-Aaron