access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · Low Priority · Version Standard

Leigh has attended:
Access Introduction course

Access

Once a Database has been created is it possible to link the data to objects in a Visio drawing and will the data update in the drawing as it is updated in the database. Or can a Visio drawing be linked by OLE?

Edited on Fri 4 Apr 2008, 09:52

RE: Access

Hi Leigh,

Sorry for the delay in getting back to you on this.

You can link Visio drawings as OLE objects.

Embedded drawings in the form - This option could be used when the developer wants to collect graphical information from the user. The diagram or graphic could be collected as an embedded drawing for temporary storage until it is committed by the user and stored either in a database or in the file system. This technique could also be used when the developer wants to generate drawings on the fly and display them to the user.

Linked Visio drawings - This option could be used when the developer wants to manage the creation and storage of a set of drawings. The user would be able to select either directly or indirectly the file or drawing they would want to display and/or edit. This option also works well as a method for viewing Visio drawings without opening Visio.

Visio drawings stored in a database - This option could be used in the same situations as linked Visio drawings where the developer is also collecting database-type information about each drawing and finds it convenient to store all the information in a database.

See also:
Visio and Visual Basic OLE Control FAQ
Sharing Visio Drawings
How to use OLE automation in Visio

I hope this helps.

Kind regards, Rich


 

Access tip:

Relationship maps

It is important to create proper relationships between tables. You can use Access to help check your designs and evaluate them by printing them in graphical format to help with design purposes


Click on the Tools menu, click Relationships.
On the File menu, click Print Relationships. View or print as required

View all Access hints and tips


Server loaded in 0.11 secs.