General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>Is it possible to reverse engineer a database from within Visio2000.
>>>I've looked at the menu options, and can't find anything that will do this.
>>>
>>>I am running Visio 2000 SR1.
>>
>>Here are the steps for 2002, see if they work.
>>
>>- create a new blank database model diagram (via File, new, database,...)
>>- you will see a database menu appear
>>- select the database menu, then Reverse Engineer
>>- in the wizard, select generic OLE DB provider, then select Visual Foxpro Ole DB provider on the next screen, on the screen after select the VFP database...
>>
>>Could you report back if Visio 2000 can do this?
>
>
>Evan I know this is an old post, but I just tried your suggestion. I am trying to document my VFP database using Visio. The strange thing is I followed your directions the first time and it created a set of tables with Relations and all. It worked somewhat well. Then I noticed one of my tables was missing a relationship. So I modified the VFP Database and added the relationship. I went back to visio and asked to create a new Database and tried to reverse engineer the VFP database again. Visio gave me the usually choses and I went through again asking for OleDb to the VFP DBC. The wizard pulled up the tables and I selected all as I did before. Now when I press OK, Visio goes off into lala land. Visio is still present and I can ALT to get to its menu, but the bell chimes if I try to do anything. I have rebooted and shutdown thinking there was some process running, but that did not work. Now I cannot get OLEBD to do anything.
>
>Any suggestions?
Sorry Brett. I only use Visio once per year or so.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only