Steve Capistrant
scapistrant at symphonyinfo.com
Fri May 9 16:54:02 CDT 2003
I love Visio. Not so much for the design stage (its faster to mock up in Access), but to publish the data model to customers. You can export your Access data model to Visio really easily and then arrange the tables using as much real estate as you want. Then bring your file to Kinko's and have them print a 2'x3' poster of your data model. The power users within the customer's organization are in heaven (assuming you provide them with some method of being exposed to the data for custom querying and reporting.). Steve Capistrant scapistrant at symphonyinfo.com Phone: 612-333-1311 Symphony Information Services www.symphonyinfo.com 212 3rd Ave N, Ste 404 Minneapolis, MN 55401 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William Hindman Sent: Friday, May 09, 2003 4:08 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Visio w/Access Normalization Jim...anyone ...I'm just now really getting into Visio ...has anyone here integrated it with Access in an application? ...my intent is to use it as the primary user interface with a tradeshow booth booking app and I'm looking for anyone who's done something similar. William Hindman ----- Original Message ----- From: "Jim Lawrence (AccessD)" <accessd at shaw.ca> To: <accessd at databaseadvisors.com> Sent: Friday, May 09, 2003 5:02 PM Subject: RE: [AccessD] Access Normalization > Hi Arthur: > > What do you think of MS Viso as a design tools? > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Arthur Fuller > Sent: Friday, May 09, 2003 5:16 AM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Access Normalization > > > Great concept, a normalization tool! > > "Yo, dumbass, these columns should be a related table, click OK to overrule > yo dumbass design, foo!" :-) > > AFAIK no one has built it yet. > > I'm a big fan of database-design tools such as Erwin, PowerDesigner and (my > fave lately) DeZign, which costs 1/10 of the price of the aforementioned and > delivers almost all their functionality. Said tools can inhale a db and turn > it into a model and let you remodel it and then exhale a db to a list of > targets, automatically converting data types etc. You can inhale Access and > exhale MySQL if that's what you want, or Oracle or DB2 or MS-SQL or Sybase. > > When I work on a new project, I spend a lot of time in DeZign before writing > a line of code. When I work on an existing project, first thing I do is > import it into DeZign. It vaguely resembles the Access Relationships window > but offers many more benefits, most notably Domains. > > (I own no shares in this company; I'm just a satisfied user.) > > Back to your question. If the db Admins have not granted her sufficient > privs to export definitions then there is no simple way around it. She is > asking either for hacker tools or for increased privs. > > Secondly, why export table definitions to Excel? Why not simple ascii files > that you can run in QA to rebuild structures? > > Arthur > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gale Perez > Sent: May 8, 2003 6:46 PM > To: accessd at databaseadvisors.com > Subject: [AccessD] Access Normalization > > > Hello! > > I haven't posted for quite a while (have been working > in Oracle, am now doing project management and working > on some Access tracking DBs). It's nice to be back > and see familiar names :) > > Is there a way to export Access table definitions into > Excel or into a normalization tool (we're using > Brackets)? I'm asking on someone else's behalf and > she has tried Export but gets the message that she > doesn't have permissions (it's not a secured > database). Can you access the data dictionary with > SQL statements? > > Thank you for any assistance, > Gale > > > __________________________________ > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com