Automating Microsoft Access (Data) Without Code

fanaticalpumaΜηχανική

5 Νοε 2013 (πριν από 3 χρόνια και 9 μήνες)

65 εμφανίσεις

Automating Microsoft Access (Data) Without Code

Automating Microsoft Access
(Data) Without Code

Daniel Ogden


Co
-
SIG Leader

NTPCUG Application Developer Issues SIG


http://appdevissues.tripod.com

http://appdevissues.tripod.com/downloads.htm

Automating Microsoft Access (Data) Without Code

Automation


Began its life as OLE Automation (OLE 2.0)


OLE Automation Server


Application capable of exposing its object model
for programmatic manipulation by automation
controller


OLE Automation Controller


Application capable of programmatically
accessing and manipulating an automation
server’s objects


Became ActiveX Automation with introduction
of ActiveX Controls (COM)


Now just called “Automation”

Automating Microsoft Access (Data) Without Code

Access as an Automation Server


Technically, it is not automation unless it is
done programmatically with an automation
controller controlling an automation server


However, the end result of automation can be
achieved using non
-
programmatic means


This requires a application that can access
Access data and internally manipulate that
data


MS Word is a good example of an application
that can achieve the results of Access
automation by non
-
programmatic means

Automating Microsoft Access (Data) Without Code

Access Capabilities as a Data
Automation Server for Word


In a non
-
programmatic setting, it is really
Access data rather than Access itself that is
automated in Word for manipulation


In a non
-
programmatic setting Word is
essence becomes a data client rather than an
automation controller


Access can exposes its tables and queries for
manipulation


Access can not expose its forms and reports
for manipulation

Automating Microsoft Access (Data) Without Code

Word as an Access Data Client


Insert Access Database


Using Pre
-
Existing Access Queries


Static Format


Dynamic Format


Using MS Query With No Pre
-
Existing Access
Queries


Static Format


Dynamic Format

Automating Microsoft Access (Data) Without Code

Word as an Access Data Client


Mail Merge from Access Database


Using Pre
-
Existing Access Queries


Using MS Query With No Pre
-
Existing Access
Queries

Automating Microsoft Access (Data) Without Code

Automating Access Data in
Word With Macros


Word’s macro recorder generates VBA code


Word
-
created VBA code can be easily manipulated to
quickly expand Access data automation