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 |
#1
|
|||
|
|||
Can you build an Access database from a Visio diagram?
I'm building a simple database app with Access, and thought that rather than
using the Access wizards, I would start the process by working out the relationship details in a Visio Database diagram. Now that I have that diagram built, can I have access building its tables and relationships automatically from the Visio? |
#2
|
|||
|
|||
There are versions of Visio that support this. Check your Visio Help for
additional information. -- Duane Hookom MS Access MVP "Pablo" wrote in message ... I'm building a simple database app with Access, and thought that rather than using the Access wizards, I would start the process by working out the relationship details in a Visio Database diagram. Now that I have that diagram built, can I have access building its tables and relationships automatically from the Visio? |
#3
|
|||
|
|||
I'm using:
Visio Professional 2003 SP1 (11.4301.6360), and I only came here after spending a lot of time in Help trying to find out how to do this. Does this version support creating (and hopefully modifying) Access table and relationship structures? Thanks "Duane Hookom" wrote: There are versions of Visio that support this. Check your Visio Help for additional information. -- Duane Hookom MS Access MVP "Pablo" wrote in message ... I'm building a simple database app with Access, and thought that rather than using the Access wizards, I would start the process by working out the relationship details in a Visio Database diagram. Now that I have that diagram built, can I have access building its tables and relationships automatically from the Visio? |
#4
|
|||
|
|||
I'm not a Visio expert, Pablo, but I don't think it does. I think the
'Enterprise Architects' edition of Visio that comes with Visual Studio is the only edition that includes that feature now. But I'm not 100% sure of that - you might get a more definitive answer in a Visio newsgroup. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Pablo" wrote in message ... I'm using: Visio Professional 2003 SP1 (11.4301.6360), and I only came here after spending a lot of time in Help trying to find out how to do this. Does this version support creating (and hopefully modifying) Access table and relationship structures? Thanks "Duane Hookom" wrote: There are versions of Visio that support this. Check your Visio Help for additional information. -- Duane Hookom MS Access MVP "Pablo" wrote in message ... I'm building a simple database app with Access, and thought that rather than using the Access wizards, I would start the process by working out the relationship details in a Visio Database diagram. Now that I have that diagram built, can I have access building its tables and relationships automatically from the Visio? |
#5
|
|||
|
|||
"=?Utf-8?B?UGFibG8=?=" wrote in
: Visio Professional 2003 SP1 (11.4301.6360), and I only came here after spending a lot of time in Help trying to find out how to do this. Does this version support creating (and hopefully modifying) Access table and relationship structures? It's one of these things that are rumoured in the marketing stuff, but I have never heard of anyone managing it, nor have I had any success myself. You can export to SQL Server or MSDE, though, which is probably more relevant if you are going to the trouble of getting visio to design the thing in the first place. Ideal solution would be a SQL DDL output, but I can't find that either. All the best Tim F |
#6
|
|||
|
|||
Turns out that I have an Enterprise Architects version with the Visual Studio
2005 Beta CDs. So I installed them, and voila, the Generate Database capability is there. Works pretty neat too, although lots of questions I don't know the answer to relative to the Access connection. Thanks for the response. PL "Brendan Reynolds" wrote: I'm not a Visio expert, Pablo, but I don't think it does. I think the 'Enterprise Architects' edition of Visio that comes with Visual Studio is the only edition that includes that feature now. But I'm not 100% sure of that - you might get a more definitive answer in a Visio newsgroup. -- Brendan Reynolds (MVP) http://brenreyn.blogspot.com The spammers and script-kiddies have succeeded in making it impossible for me to use a real e-mail address in public newsgroups. E-mail replies to this post will be deleted without being read. Any e-mail claiming to be from brenreyn at indigo dot ie that is not digitally signed by me with a GlobalSign digital certificate is a forgery and should be deleted without being read. Follow-up questions should in general be posted to the newsgroup, but if you have a good reason to send me e-mail, you'll find a useable e-mail address at the URL above. "Pablo" wrote in message ... I'm using: Visio Professional 2003 SP1 (11.4301.6360), and I only came here after spending a lot of time in Help trying to find out how to do this. Does this version support creating (and hopefully modifying) Access table and relationship structures? Thanks "Duane Hookom" wrote: There are versions of Visio that support this. Check your Visio Help for additional information. -- Duane Hookom MS Access MVP "Pablo" wrote in message ... I'm building a simple database app with Access, and thought that rather than using the Access wizards, I would start the process by working out the relationship details in a Visio Database diagram. Now that I have that diagram built, can I have access building its tables and relationships automatically from the Visio? |
#7
|
|||
|
|||
Tim: It's in the Vision Enterprise Architect's version, and I happen to have
a copy with the Whidbey beta disks. Works pretty neat. Thanks for the reply PL "Tim Ferguson" wrote: "=?Utf-8?B?UGFibG8=?=" wrote in : Visio Professional 2003 SP1 (11.4301.6360), and I only came here after spending a lot of time in Help trying to find out how to do this. Does this version support creating (and hopefully modifying) Access table and relationship structures? It's one of these things that are rumoured in the marketing stuff, but I have never heard of anyone managing it, nor have I had any success myself. You can export to SQL Server or MSDE, though, which is probably more relevant if you are going to the trouble of getting visio to design the thing in the first place. Ideal solution would be a SQL DDL output, but I can't find that either. All the best Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cannot change password | Richard | General Discussion | 13 | November 14th, 2004 10:00 PM |
MICROSOFT INVESTING HEAVILY IN ACCESS | Mike Painter | General Discussion | 39 | October 15th, 2004 03:56 PM |
Pocket Access - Sync to Linked Table? | Jason Gyetko | General Discussion | 6 | July 8th, 2004 05:23 PM |
Opening Access database from Excel | Tim Poirier | Links and Linking | 7 | May 11th, 2004 02:10 PM |