|
6 of 7 people found the following review helpful:
1.0 out of 5 stars
Okay for abstract principles, poor on practicalities., 27 May 2000
By A Customer
This book is okay on presenting the principles of database layout, but doesn't live up to its front cover claim "what you really need to know to develop with access". The book explains some underlying DB concepts quite well, but the author clearly did not have a list of common, practical problems in mind when he put pen to paper.My expectations from an O'Reilly book are high, and this book doesn't match up. Three indicative irritations were: * The section on Jet RecordSet properties, which ends "Of course, getting documentation on these properties is another matter. Let me know if you find any." * The bit on manipulating dates: "If you need to manipulate dates or times in your programs, you should probably spend some time with the Access VBA help file. (Start by looking under Date Data Type)" * No information on using autonumbered fields, which didn't even make the index. If you want to know which code is best to recover the data you just entered into an autonumbered row, you probably won't be able to work it out from this book. The book is mainly written in terms of the earlier Microsoft DAO technology, with a single chapter on ADO tacked on. My (2nd ed) version does not address MSDE or Access 2000 specifics, of course. The language used is VBA, so issues that crop up with other languages, like VBScript's lack of typing, are not covered. Writing with later upsizing in mind is also not addressed, although some differences between SQL-92 and Access SQL are mentioned in passing. There is also little indication of how complete the SQL information is.
|