![]() ![]() If you use a DAO Recordset, you must explicitly reference it. #1: Eliminate ambiguous objectsĪDO is the default object library for Access, but DAO is still available. Note: This information is also available as a PDF download. Luckily, you can avoid some of the most common mistakes if you just plan for them. No matter how experienced you are, it’s difficult to commit every little behavior and requirement to memory. ![]() Often, we’re unaware of a subtle nuance between the two object libraries, Data Access Objects (DAO) and ActiveX Data Objects (ADO). But it’s easy to go astray, and there are a number of mistakes that even experts make. Susan Harkins explains 12 common Recordset pitfalls you can anticipate and avoid.Īs an Access developer - or even as a power user - you won’t get far if you can’t work with the Recordset object. The Recordset object is an essential component in Access development, but it often trips up even experienced developers. 10+ mistakes to avoid when using VBA Recordset objects
0 Comments
Leave a Reply. |