98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · 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?
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Relationship mapsIt 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 |