[AccessD] Visio w/Access Normalization

Jim Lawrence (AccessD) accessd at shaw.ca
Fri May 9 20:14:29 CDT 2003


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



More information about the AccessD mailing list