Whats a really good Access book?

[BlackTL]

I need a really good Access book that will help me learn how to write modules etc for a beginner. I can program in other languages but have never found a descent book for Access. I just basically have to learn the syntax etc. for writing these things.

Thanks
Rosh

 

[psemianonymous]

The Access (version number) Developer's Handbook is good--lots of code examples, and it comes with a CD with sample DBs. You can look at the Access-included Northwind database to see "how it's done", though it doesn't necessarily use the best coding practices.

Anyway, the Access Developer's Handbook is good for me because it gives *good practices* information instead of simple informational fluff. Like a section on how and why to use DBEngine(0)(0) vs CurrentDB() to grab a Database object, and whether or not using CurrentDB.Close does anything (it doesn't), and why you should set all your variables to Nothing at the end of a subroutine and...

etc


It's a good book. I haven't read any others on the topic of Access, so no comparisons.

 

[markgrizzle]

I second foolio. Access Developer's Handbook by Getz/Litwin/Gilbert is very good.

You may also want to get a copy of ADO 2.1 Programmer's Reference from Wrox Press.

 

[SQLBI]

I agree with the others on this.

Amazon do a Desktop and Enterprise Developers handbook twin set which will quickly become your bible.

Not to be confused with the Access Bible series which is not very helpful for anyone other than beginers/inexperienced users.

From the same publishers as the Dev Handbooks, the Access VBA handbook is also worth a read.

HTH.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[BlackTL]

Thanks guys, I just picked up the Access Developer's Handbook... It looks like it will be VERY helpful!

Thanks!