MS Access as a Super Dataset

1
MS Access as a Super Dataset

• 17-June-2009
• by
• Barry Hynum, Ph.D.
• MaxQual Consulting

2
Disconnected Data gtgt DS

• .Net Datasets allow for complex disconnected data
• Multiple Tables
• Relationships
• Fully query-able
• Select, Update, Insert

3
DS Engineering

• Use VS.Net
• See ADO.Net by David Sceppa

4
MS Access as Super DS

• Disconnected
• Multiple Tables
• Relationships
• Fully Query-able

5
SQL Server
6
(No Transcript)
7
Get Recordset, pg 1
8
Get Recordset, pg 2
9
Stored Procedure for GET
10
Stored Procedures for Update Insert
11
MS Access

• Not LINKED
• Loaded via ADO

12
MS Access Relationships
13
Main Data Entry Form w/ Multiple Subforms
Subform Linking
14
Subforms

• All based on sub-Table Record Source
• Linked via AcctID
• Locally Updateable
• Local Automatic Insert

15
Exit/Save
16
Common Table Update/Insert Class Procedure, pg 1
Automatic Parameters
17
Common Table Update/Insert Class Procedure, pg 2
18
Cleanup Error Handling
19
Form Dimensions

• InsideWidth
• InsideHeight
• Can be set in a procedure in the target Form but
  doesnt work unless called externally.

20
Form Dimensions
Called externally DoCmd.OpenForm
frm_Example Form_frm_Example.sb_ResetSubFormLoc
ations (must be Public)