How to Open a Recordset

Submit Your Tip

How to Open a Recordset – This is a place for the community to provide tips and advice on How to Open a Recordset. This topic was created by Morwen Madrigal and the tips are provided by the community. The tips you add here can be your own or referred from another site. The best tips are then ranked at the top when up-voted by members of the community.

Tip 1 - MS Access VBA ADODB Recordset.Open table OK but SQL fails

Published: 9 years, 1 month(s) ago | Submitted by Hein Heyster | permalink

I have an MS Access 2007 table: Columns are DB, Module, CommentID, and Comment I have an SQL query that returns the correct record in MS Access Query Design. I have confirmed in the Immediate

For further reading: http://stackoverflow.com/questions/10264764/ms-access-vba-adodb-recordset-open-table-ok-but-sql-fails ^[1]

Tip 2 - Open recordset in Access 2003/2007

Published: 9 years, 1 month(s) ago | Submitted by Lisa Hester | permalink

It's been years since I've worked in Access code and it is making me certifiably insane. I just don't remember anything and all I want to do is open a recordset in code and nothing I've found onli...

For further reading: http://stackoverflow.com/questions/6034959/open-recordset-in-access-2003-2007 ^[2]

Tip 3 - ADO, Tutorials, Example Code, Reference, Resources, Help

Published: 9 years, 1 month(s) ago | Submitted by mstansfield | permalink

The DevGuru ADO Quick Reference is the definitive ADO reference and tutorial resource on the web, with hundreds of ready to use examples for you to include in your projects.
Tags: help, database, SQL, tutorial, howto, ADO basics, ADO, Help, ADO, Tutorials, ADO, Programming, ADO, Code, ADO, Free

For further reading: http://www.devguru.com/technologies/ado/8686 ^[3]