[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