Sending Data to Access

With the communication channel now open to the database, you can now send data from a Visio diagram to an Access database via the channel using DAO as in Listing 22.3.

Listing 22.3. Sending Data from a Diagram to Acess via DAO
 Public g_dbsMyDatabase As DAO.Database Public g_szDBFileName As String Public g_bTrack As Boolean Global Const g_szDefFileName$ = "d:\MyDatabase.mdb" Global Const g_nFileNotFound% = &HFFFFFFFF Global Const g_szTableName$ = "Item" Global Const g_szFieldCost$ = "ItemCost" Global Const g_szFieldName$ = "ItemName" Global Const g_szFieldGUID$ = "ItemID" Global Const g_szUserFileName$ = "User.DBFileName" Global Const g_szUserTrack$ = "User.Track" Global Const g_szPropTrack$ = "Prop.Track" Global Const ...

Get Professional Development with Visio® 2000 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.