Comments about oreilly Fixing Access Annoyances:

I bought this book because when viewed on Google books it showed a section referring to Access's annoying default of setting subdatasheet names to [Auto] causing very slow opening of tables under certain circumstances. More specifically the text said that if the reader didn't want to change this table by table to see the section on "Defaults for tables and queries":

"To prevent this from happening, open your table

in Design View, open its properties sheet (View→Properties), and set

Subdatasheet Name to "[None]." (If you don't want to do this for every

table, see "Defaults for Tables, Queries, and Datasheets," later in this

chapter.)"

This "Defaults for Tables, Queries, and Datasheets" section was not visible on Google Books but sounded very promising.

Given the promise, I bought the book and have now read the section on "defaults" referred to so appealingly.

In fact, this section provides no means of changing the problematic default of "[Auto]". It does refer to a Microsoft explanation of how to correct this unfortunate default retrospectively table by table using VBA but that is a very different matter to changing the default. I had already found and used this publicly accessible Microsoft support information but had noted that the problem reappeared any time I created a new table, e.g. via a make table query. I was looking for a way to change the default rather than patch it up afterwards as the latter took time.

In that respect, I have wasted my money and more importantly my own time. The book may well have lots of good material and I may have been unlucky in stumbling across the one aspect that didn't live up to its promise. But as always, Buyer beware.

Sincerely,

Stephen Walsh

Comments about oreilly Fixing Access Annoyances:

I've had this book for 3 plus months now and have been reading it off and on as I've gotten time during work - its so full of great advice and insights into Access that it is very much worth the full retail I actually paid for it (and you can't say that about many computer books). I've used Access for 4 years now and I've learned some great stuff that I would never have picked up in my day-to-day use of the software. Excellent read and very informative.