January 28, 2021
Hot Topics:

Visual Basic Database Tutorial - Part 4

  • By Karl Moore
  • Send Email »
  • More Articles »

Before we start coding with the database objects I mentioned earlier, we need to tell Visual Basic we're going to use them. To get those objects into our project, we need to set a "reference" to them - by clicking Project, References. You should be presented with a list longer than Bill Clinton's "To Do" pad.

Scroll down to the ones starting 'Microsoft DAO'.

Top Tip: DAO stands for Data Access Objects, though its considered better taste to use the confusing three-letter acronym instead

Youll notice quite a few there. DAO 2.5, 3.0, 3.51, 3.6 - Zzzzz......

Every now and then, Microsoft likes to unveil new versions to access the latest database formats. For example, you should open Access 97 databases using DAO 3.51. And if youre wanting to plug into an Access 2000 database, youll want to choose DAO 3.6.

Were going to access the Nwind.mdb database again, which is an Access 97 database. So click the checkbox next to Microsoft DAO 3.51 Object Library and click OK.

Brilliant! In the next section, well get down to the real groovy stuff, something even more exciting than the Bumper Book of Italian Marriage Laws... actual database code!

[Sarcastic Ed: Gee, Im getting SO excited already... ]

Page 4 of 8

This article was originally published on November 20, 2002

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date