William Hindman
wdhindman at bellsouth.net
Sat May 10 12:16:54 CDT 2003
...thanks Lembit ...looks like I'm overdue there :))) William Hindman ----- Original Message ----- From: "Lembit Soobik" <Lembit.Soobik at t-online.de> To: <accessd at databaseadvisors.com> Sent: Saturday, May 10, 2003 8:38 AM Subject: Re: [AccessD] Visio w/Access Normalization > there are 38 subscribers on this list > > Lembit Soobik > > ----- Original Message ----- > From: "William Hindman" <wdhindman at bellsouth.net> > To: <accessd at databaseadvisors.com> > Sent: Saturday, May 10, 2003 3:25 AM > Subject: Re: [AccessD] Visio w/Access Normalization > > > > ...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 > > > > > > > > > _______________________________________________ > > 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 >