Back

Topic

[KB779]Connecting to an Access database using VBA and ADO

Tags: ADO, VBA

10 years ago
By RM
Options
Print
Applies to:

PcVue 8.10 onwards


Summary:

A sample project including simple VBA routines to connect and manage an Access database using ADO (Active Data Objects)


Details:

The project includes sub-routines to connect and disconnect to a database and display, add, delete and update fields.

Note 1. The project was saved with PcVue 10.0 SP1 but the mimic is saved in ASCII mode and so can be viewed with a text editor.

Note 2. This article includes a video. See the download links at the end of the article.

vba_ado_access_small


Sample project:

VBA_ADO.zip

Download attachments:


Created on: 13 Apr 2015 Last update: 13 May 2024