by TheVBPro (4 Submissions)
Category: Databases/Data Access/DAO/ADO
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(2 Votes)
This tutorial / demo app shows you how to process an Access database using "old school" DAO (Data Access Objects) code. Covered in the tutorial is the DAO Object Model, as well as methods for recordset processing, searching, inserting, updating, deleting, etc. The sample app also uses Crystal Reports (the version that came with VB6 and VB5, not a commercial version). The Employee.mdb file that is part of this sample app is Access 97 format, and it MUST be 97 as the old version of Crystal cannot read anything higher. (If you have Access 200X, the higher version of Access will be able to read this database, but don't accept any of its offers to convert it for you.)
Download Process Access DB using DAO (313 KB)
VBcoders