William Hindman
wdhindman at bellsouth.net
Fri May 9 20:25:59 CDT 2003
...did we ever get a dba-Visio list started? ...is there enough interest in one to make it worthwhile? William Hindman ----- Original Message ----- From: "Jim Lawrence (AccessD)" <accessd at shaw.ca> To: <accessd at databaseadvisors.com> Sent: Friday, May 09, 2003 9:14 PM Subject: RE: [AccessD] Visio w/Access Normalization > Charlotte: > > Thank you for that little tip. > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte > Foust > Sent: Friday, May 09, 2003 2:55 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Visio w/Access Normalization > > > I've maintained network data using Visio in the past, if that applies. > Be careful about numeric values though because unless you do a lot of > careful tweaking to your Visio FE shapes' properties, you'll wind up > with doubles in the BE, whether that's what you wanted or not. As you > might expect, doubles aren't terribly useful for MAC addresses, etc.. > <G> > > Charlotte Foust > > -----Original Message----- > From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] > Sent: Friday, May 09, 2003 1:33 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Visio w/Access Normalization > > > William: > > Not I, but I have used it on a MS SQL a few times, it finds the schema, > displays the structure and fields, I make a few changes, upload and > amazingly the DB and data is still there after all is said and done. > Works like the BackEnd Upgrader (BEU) from Bryan Carbonnell, Reuben > Cummings and Andy Lacey but for SQL. > > I didn't know it could be used as a FE user interface... I would like to > hear more. > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of William > Hindman > Sent: Friday, May 09, 2003 2: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 > > _______________________________________________ > 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 >