A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Generating a database from Visio Modeler



 
 
Thread Tools Display Modes
  #1  
Old September 3rd, 2004, 02:33 AM
IP
external usenet poster
 
Posts: n/a
Default Generating a database from Visio Modeler

I am working with Visio Modeler 3.1 generating a database.
My OR model appears to be OK, and I'm successful building
the dictionary.
However, I have been unsuccessful when trying to generate a
physical database schema, I cannot open the database in
Microsoft Access 2000. There is message telling me that
Microsoft Access cannot find such a file. I also tried to
generate a DLL script and running it, but I got the following:
Warning! Target DBMS does not have object-relational
aggregate support. No aggregates will be generated or updated.
-- Make sure you have the right DBMS or preferred version
selected properly in the driver setup dialog box.
What I need to do to fix this problem.
As you may guess, I am novice designing databases. So I
would appreciate precise and clear directions.
Thanks.



  #2  
Old September 3rd, 2004, 05:32 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default

"IP" wrote in news:553101c49156
:

I am working with Visio Modeler 3.1 generating a database.


This sounds more like a problem for the visio group... Have you tried
m.p.visio.database or m.p.visio.database.modelling?

Tim F

  #3  
Old September 3rd, 2004, 07:02 PM
IP
external usenet poster
 
Posts: n/a
Default

Yes. Thank you. I posted my question in those groups.

Now, I 'm thinking the problem maybe that my Access is newer than my Visio,
and some drivers maybe different.

"Tim Ferguson" wrote:

"IP" wrote in news:553101c49156
:

I am working with Visio Modeler 3.1 generating a database.


This sounds more like a problem for the visio group... Have you tried
m.p.visio.database or m.p.visio.database.modelling?

Tim F


  #4  
Old September 4th, 2004, 07:07 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default

"=?Utf-8?B?SVA=?=" wrote in
:


Now, I 'm thinking the problem maybe that my Access is newer than my
Visio, and some drivers maybe different.



Hmmm... can't offer any specific help in that direction. Actually,
following your OP, I tried to use Visio Pro to make an mdb and got
absolutely nowhere!

Then again, the table designer in Access is probably just as quick, and you
can (now) print the relationships window, if you don't have any prior
documentation.

All the best


Tim F

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What is MDE Charlie General Discussion 4 August 24th, 2004 04:15 PM
Visio Pro 2003 crashes when trying to ope a Database Diagram Model mrlegend90 Visio 2 August 7th, 2004 07:02 PM
Link excel data to a visio 2002 professional shape Darrick Visio 1 August 3rd, 2004 09:09 PM
Visio Most Recent Version RobC Visio 2 July 16th, 2004 08:28 PM
Mutliple Tables lookup? Westley Database Design 4 June 15th, 2004 01:07 AM


All times are GMT +1. The time now is 01:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.