I spend a great deal of time searching for solutions to weird programming problems under certain platforms. PHP has a good developer community and it’s easy to find answers in the comment boards below the online manual entry for each function, and usually the developers who post there are pretty knowledgeable.
Access is a different story though, because there’s no “official” site like there is for PHP where discussions can take place, and also because Access developers tend to span the entire spectrum of complete beginners who have just started dragging things around and barely write any code, to people who write VBA code using whole libraries of Windows API functions. The beginners are generally the ones asking questions, so most of the information space online is taken up by repeated references to the same sorts of questions.
And anyway, the “no official discussion space” problem is the most severe. I find that the discussions on Experts Exchange are usually pretty informative, whereas other sites tend to go downhill from there. When you’re looking for information, or an article addressing a specific problem, why wade through the entire Internet? Unfortunately there’s no choice, and 95% of the pages returned by Google are irrelevant.
For example, I was searching for why a simple JOIN expression won’t work using DAO databases and the “OpenRecordset” function. Let’s say I want:
dim db as Database
set db = CodeDb
dim rs as Recordset
set rs = db.OpenRecordset(“SELECT * FROM a INNER JOIN b ON a.key=b.key”)
For some reason, that doesn’t work. It’ll work fine in the Query Builder and when you save it as a query, but not in code. So the workaround is to just do:
set rs = db.OpenRecordset(“SELECT * FROM a,b WHERE a.key=b.key”)
But that’s a limitation because you can only simulate inner joins. I’m sure the answer is out there, but I haven’t gotten around to wading through the tons of detrius out there also to find it. I think knowledge-bases can be improved significantly, perhaps by using the Wikipedia model and allowing users to modify a single article stating an issue and addressing it clearly, rather than using the discussion-board approach which generates a lot of noise.