If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Data does not refresh to drawing.
As a question
"Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and Access all on the same client workstation? ........ "AlEdlund" wrote in message news If you're going to use the database wizard, I'd start over here http://office.microsoft.com/en-us/vi...191751033.aspx If you're going to use datalinking, I'd start over here http://office.microsoft.com/training...RC101977211033 al "Ken N" wrote in message ... Running XP Pro on a Network with Visio 2007: Under tools I did use the “Database Wizard” Following the wizard through- Link shapes to database records Shapes in drawing Select shapes Choose source Table Choose Prim-Key Field Choose default key or click none If I choose none it does nothing!! If I choose default it changes all to the default. But neither give me a workable link. No linked table and a error message when I try to refresh – -- Ken N "Ken N" wrote: I have reworded the question in a new thread dated today 6/25/09. The problem is linking to the existing shape without creating a new datagraphic. --Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#12
|
|||
|
|||
Data does not refresh to drawing.
No, Access is on a server, I can link to the database. My problem is linking
the original shape. The original shape is just a rectangle that was imported from CAD. It had two properties (a room number and name) that I want linked to the database. Because the room number and the door numbers look similar we do not show the room number on the drawing and I am using it as the key. I exported the data from the drawing originally so it would make sense that I should be able to link back to it. The only part of the shape that is visible is the room name so it acts like a label for the room. I cannot seem to tie the two together without creating a new datagraphic. The drawings take up enough space without adding redundancy, which I do not want. Monday I will try to make a linked master. I do not have the path to the “Master Database” so I will have to wait for my IT dept to show up. (See if I keep resetting their servers!) -- Ken N "AlEdlund" wrote: As a question "Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and Access all on the same client workstation? ........ "AlEdlund" wrote in message news If you're going to use the database wizard, I'd start over here http://office.microsoft.com/en-us/vi...191751033.aspx If you're going to use datalinking, I'd start over here http://office.microsoft.com/training...RC101977211033 al "Ken N" wrote in message ... Running XP Pro on a Network with Visio 2007: Under tools I did use the “Database Wizard” Following the wizard through- Link shapes to database records Shapes in drawing Select shapes Choose source Table Choose Prim-Key Field Choose default key or click none If I choose none it does nothing!! If I choose default it changes all to the default. But neither give me a workable link. No linked table and a error message when I try to refresh – -- Ken N "Ken N" wrote: I have reworded the question in a new thread dated today 6/25/09. The problem is linking to the existing shape without creating a new datagraphic. --Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#13
|
|||
|
|||
Data does not refresh to drawing.
can you share the drawing you are trying to export/import?
al "Ken N" wrote in message ... No, Access is on a server, I can link to the database. My problem is linking the original shape. The original shape is just a rectangle that was imported from CAD. It had two properties (a room number and name) that I want linked to the database. Because the room number and the door numbers look similar we do not show the room number on the drawing and I am using it as the key. I exported the data from the drawing originally so it would make sense that I should be able to link back to it. The only part of the shape that is visible is the room name so it acts like a label for the room. I cannot seem to tie the two together without creating a new datagraphic. The drawings take up enough space without adding redundancy, which I do not want. Monday I will try to make a linked master. I do not have the path to the “Master Database” so I will have to wait for my IT dept to show up. (See if I keep resetting their servers!) -- Ken N "AlEdlund" wrote: As a question "Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and Access all on the same client workstation? ........ "AlEdlund" wrote in message news If you're going to use the database wizard, I'd start over here http://office.microsoft.com/en-us/vi...191751033.aspx If you're going to use datalinking, I'd start over here http://office.microsoft.com/training...RC101977211033 al "Ken N" wrote in message ... Running XP Pro on a Network with Visio 2007: Under tools I did use the “Database Wizard” Following the wizard through- Link shapes to database records Shapes in drawing Select shapes Choose source Table Choose Prim-Key Field Choose default key or click none If I choose none it does nothing!! If I choose default it changes all to the default. But neither give me a workable link. No linked table and a error message when I try to refresh – -- Ken N "Ken N" wrote: I have reworded the question in a new thread dated today 6/25/09. The problem is linking to the existing shape without creating a new datagraphic. --Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#14
|
|||
|
|||
Data does not refresh to drawing.
I am not sure I can legally do, I have tried working with the wizard then
copying field from the new corresponding master over to the existing shape sheet. It seems promising but the data still will not refresh. This is the- User-Defined Cells ODBCConnection="ODBCDataSource=MS Access Database|ODBCQualifier=Z:\OSPKeyBE|ODBCTable=tblRo omName|2|Prop_XXXXX=Prop.XXXXX|Prop_Row_1=Prop.Row _1|1|ShapeKey=Prop.ShapeKey=32|" "This cell contains the link information for the Database Wizard." User.ODBCChecksum="d91ae3e1" "This cell contains a checksum of the database record." This lets me select records but does not refresh. If you have some influence, you could convince MS to allow us to print or copy shape sheets. This in itself would make working with shapes easier. -- Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#15
|
|||
|
|||
Data does not refresh to drawing.
Hello Ken,
If you download the Visio 2007 SDK, you'll find you get a "Print ShapeSheet" function under Tools / Add-Ons / SDK http://www.microsoft.com/downloads/d...displaylang=en Best regards John John Goldsmith (Visio MVP) www.visualSignals.typepad.co.uk www.visualSignals.co.uk "Ken N" wrote in message ... I am not sure I can legally do, I have tried working with the wizard then copying field from the new corresponding master over to the existing shape sheet. It seems promising but the data still will not refresh. This is the- User-Defined Cells ODBCConnection="ODBCDataSource=MS Access Database|ODBCQualifier=Z:\OSPKeyBE|ODBCTable=tblRo omName|2|Prop_XXXXX=Prop.XXXXX|Prop_Row_1=Prop.Row _1|1|ShapeKey=Prop.ShapeKey=32|" "This cell contains the link information for the Database Wizard." User.ODBCChecksum="d91ae3e1" "This cell contains a checksum of the database record." This lets me select records but does not refresh. If you have some influence, you could convince MS to allow us to print or copy shape sheets. This in itself would make working with shapes easier. -- Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#16
|
|||
|
|||
Data does not refresh to drawing.
I could send a portion of the drawing. Can you see my e-mail address at
odrc.state.oh -- Ken N "AlEdlund" wrote: can you share the drawing you are trying to export/import? al "Ken N" wrote in message ... No, Access is on a server, I can link to the database. My problem is linking the original shape. The original shape is just a rectangle that was imported from CAD. It had two properties (a room number and name) that I want linked to the database. Because the room number and the door numbers look similar we do not show the room number on the drawing and I am using it as the key. I exported the data from the drawing originally so it would make sense that I should be able to link back to it. The only part of the shape that is visible is the room name so it acts like a label for the room. I cannot seem to tie the two together without creating a new datagraphic. The drawings take up enough space without adding redundancy, which I do not want. Monday I will try to make a linked master. I do not have the path to the “Master Database” so I will have to wait for my IT dept to show up. (See if I keep resetting their servers!) -- Ken N "AlEdlund" wrote: As a question "Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and Access all on the same client workstation? ........ "AlEdlund" wrote in message news If you're going to use the database wizard, I'd start over here http://office.microsoft.com/en-us/vi...191751033.aspx If you're going to use datalinking, I'd start over here http://office.microsoft.com/training...RC101977211033 al "Ken N" wrote in message ... Running XP Pro on a Network with Visio 2007: Under tools I did use the “Database Wizard” Following the wizard through- Link shapes to database records Shapes in drawing Select shapes Choose source Table Choose Prim-Key Field Choose default key or click none If I choose none it does nothing!! If I choose default it changes all to the default. But neither give me a workable link. No linked table and a error message when I try to refresh – -- Ken N "Ken N" wrote: I have reworded the question in a new thread dated today 6/25/09. The problem is linking to the existing shape without creating a new datagraphic. --Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#17
|
|||
|
|||
Data does not refresh to drawing.
all I see is the kenN..
You can use edlund60014 over on yahoo.. al "Ken N" wrote in message ... I could send a portion of the drawing. Can you see my e-mail address at odrc.state.oh -- Ken N "AlEdlund" wrote: can you share the drawing you are trying to export/import? al "Ken N" wrote in message ... No, Access is on a server, I can link to the database. My problem is linking the original shape. The original shape is just a rectangle that was imported from CAD. It had two properties (a room number and name) that I want linked to the database. Because the room number and the door numbers look similar we do not show the room number on the drawing and I am using it as the key. I exported the data from the drawing originally so it would make sense that I should be able to link back to it. The only part of the shape that is visible is the room name so it acts like a label for the room. I cannot seem to tie the two together without creating a new datagraphic. The drawings take up enough space without adding redundancy, which I do not want. Monday I will try to make a linked master. I do not have the path to the “Master Database” so I will have to wait for my IT dept to show up. (See if I keep resetting their servers!) -- Ken N "AlEdlund" wrote: As a question "Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and Access all on the same client workstation? ........ "AlEdlund" wrote in message news If you're going to use the database wizard, I'd start over here http://office.microsoft.com/en-us/vi...191751033.aspx If you're going to use datalinking, I'd start over here http://office.microsoft.com/training...RC101977211033 al "Ken N" wrote in message ... Running XP Pro on a Network with Visio 2007: Under tools I did use the “Database Wizard” Following the wizard through- Link shapes to database records Shapes in drawing Select shapes Choose source Table Choose Prim-Key Field Choose default key or click none If I choose none it does nothing!! If I choose default it changes all to the default. But neither give me a workable link. No linked table and a error message when I try to refresh – -- Ken N "Ken N" wrote: I have reworded the question in a new thread dated today 6/25/09. The problem is linking to the existing shape without creating a new datagraphic. --Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#18
|
|||
|
|||
Data does not refresh to drawing.
I suggested adding a macro to refresh the drawing
al Public Sub DoRefresh() Dim myPage As Visio.Page Dim myDoc As Visio.Document Set myDoc = Visio.Application.ActiveDocument For Each myPage In myDoc.Pages RUNADDON ("DBRS") ' MsgBox CStr(myPage.Name) Next myPage End Sub "AlEdlund" wrote in message ... all I see is the kenN.. You can use edlund60014 over on yahoo.. al "Ken N" wrote in message ... I could send a portion of the drawing. Can you see my e-mail address at odrc.state.oh -- Ken N "AlEdlund" wrote: can you share the drawing you are trying to export/import? al "Ken N" wrote in message ... No, Access is on a server, I can link to the database. My problem is linking the original shape. The original shape is just a rectangle that was imported from CAD. It had two properties (a room number and name) that I want linked to the database. Because the room number and the door numbers look similar we do not show the room number on the drawing and I am using it as the key. I exported the data from the drawing originally so it would make sense that I should be able to link back to it. The only part of the shape that is visible is the room name so it acts like a label for the room. I cannot seem to tie the two together without creating a new datagraphic. The drawings take up enough space without adding redundancy, which I do not want. Monday I will try to make a linked master. I do not have the path to the “Master Database” so I will have to wait for my IT dept to show up. (See if I keep resetting their servers!) -- Ken N "AlEdlund" wrote: As a question "Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and Access all on the same client workstation? ........ "AlEdlund" wrote in message news If you're going to use the database wizard, I'd start over here http://office.microsoft.com/en-us/vi...191751033.aspx If you're going to use datalinking, I'd start over here http://office.microsoft.com/training...RC101977211033 al "Ken N" wrote in message ... Running XP Pro on a Network with Visio 2007: Under tools I did use the “Database Wizard” Following the wizard through- Link shapes to database records Shapes in drawing Select shapes Choose source Table Choose Prim-Key Field Choose default key or click none If I choose none it does nothing!! If I choose default it changes all to the default. But neither give me a workable link. No linked table and a error message when I try to refresh – -- Ken N "Ken N" wrote: I have reworded the question in a new thread dated today 6/25/09. The problem is linking to the existing shape without creating a new datagraphic. --Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
#19
|
|||
|
|||
Data does not refresh to drawing.
a v2007 version for refresh
Public Sub DoRefresh() Dim myPage As Visio.Page Dim myDoc As Visio.Document Set myDoc = Visio.Application.ActiveDocument Dim visAddons As Visio.Addons Dim addonDBRS As Visio.Addon Set visAddons = Application.Addons Set addonDBRS = visAddons("DBRS") For Each myPage In myDoc.Pages addonDBRS.Run "" ' MsgBox CStr(myPage.Name) Next myPage End Sub "AlEdlund" wrote in message ... all I see is the kenN.. You can use edlund60014 over on yahoo.. al "Ken N" wrote in message ... I could send a portion of the drawing. Can you see my e-mail address at odrc.state.oh -- Ken N "AlEdlund" wrote: can you share the drawing you are trying to export/import? al "Ken N" wrote in message ... No, Access is on a server, I can link to the database. My problem is linking the original shape. The original shape is just a rectangle that was imported from CAD. It had two properties (a room number and name) that I want linked to the database. Because the room number and the door numbers look similar we do not show the room number on the drawing and I am using it as the key. I exported the data from the drawing originally so it would make sense that I should be able to link back to it. The only part of the shape that is visible is the room name so it acts like a label for the room. I cannot seem to tie the two together without creating a new datagraphic. The drawings take up enough space without adding redundancy, which I do not want. Monday I will try to make a linked master. I do not have the path to the “Master Database” so I will have to wait for my IT dept to show up. (See if I keep resetting their servers!) -- Ken N "AlEdlund" wrote: As a question "Running XP Pro on a Network with Visio 2007", are Visio, the drawing, and Access all on the same client workstation? ........ "AlEdlund" wrote in message news If you're going to use the database wizard, I'd start over here http://office.microsoft.com/en-us/vi...191751033.aspx If you're going to use datalinking, I'd start over here http://office.microsoft.com/training...RC101977211033 al "Ken N" wrote in message ... Running XP Pro on a Network with Visio 2007: Under tools I did use the “Database Wizard” Following the wizard through- Link shapes to database records Shapes in drawing Select shapes Choose source Table Choose Prim-Key Field Choose default key or click none If I choose none it does nothing!! If I choose default it changes all to the default. But neither give me a workable link. No linked table and a error message when I try to refresh – -- Ken N "Ken N" wrote: I have reworded the question in a new thread dated today 6/25/09. The problem is linking to the existing shape without creating a new datagraphic. --Ken N "AlEdlund" wrote: In the left hand column of the table in the external data window, is there a little chain link displayed? This shows that the record and the shape are linked. If I remember correctly, if you edit a shape manually the link will be broken and you will have to relink the shape to the record. al "Ken N" wrote in message ... I used the wizard, the access table was built from the drawing so all data and column names were the same at the start. There is only the one table in the external data window. When I refresh that table, it will update, but not the shape. I have done this before and had no problems on shapes that I built. "AlEdlund" wrote: How are you linking the data to Access (the data linking is a read only process, the database wizard round trips but the fields have to have been in the shapes when you started)? If you select from the menu bar view = external data window, how many tables show up? al "Ken N" wrote in message news I am working with a Visio drawing created with 2007 Pro, the columns in Access are the same as what they are labeled in Visio. (The Data came from the drawing.) The table in Visio will update to the Access Databse but the shape will not! I selected automaticaly link to do the whole page. I have also linked a single record and it will not update. "AlEdlund" wrote: which drawing are you referring to (the cad or the visio)? Are you using v2007 pro? Does the shape have a shapedata/property with the same name as the access datafield? If you 'drag' the external datarecord field from the external data table to the shape, does it apply? al "Ken" wrote in message ... I extracted data from a Visio Drawing that was from a converted CAD DWG file. I then linked it back to Visio from Access. It will refresh the linked table but not the data on the shape in my drawing!?! Any sugestions? |
|
Thread Tools | |
Display Modes | |
|
|