Microsoft Access Database Tips
This past week I struggled valiantly against an Access database which would do nothing but tell me that a recordset was not updateable. Microsoft’s help database lists roughly 25 reasons this can happen. I want to share the root of my problem and another handy excel tip.
If you are the unfortunate recipient of the error, this recordset is not updatable then the first stop you should make is to your relationship table. Once there right click and show all. After that make sure all your tables which show are linked appropriately. Link the tables correctly avoiding one to many relationships.
After you make those changes don’t forget that clicking the list view icon does not run the query in the same sense that double clicking on a query form the list menu does or clicking on the red exclamation point.
Good Luck Accessing and such.
Josh Smith is a blogger, database manager and adjunct professor of business and technology. 
I’m one of those pesky self trained guys, sorry. I can extract from a long list of Yes/No items to a report. I’ve tried a query for “true” on each item (was suggested) and returned no result neither with the Column shown or not.
If I could just find ythe right book to study. I prefer to not have to learn VB right now and would like to avoid SQL if poss. I just need a book/s that go beyond the basics of how to build a DB. even something ERA 2000 that still focused on conventional Access advanced eaching.
This should be simple…but I’m having difficulty. I have a form that has an option group. Based on the choice made in the option group will determine where the “Next” button takes me….OK? I have that much figured out. When I click on the “Next” button and the appropriate form opens, how do I get the form I just left to close????