Charlotte Foust
cfoust at infostatsystems.com
Fri May 9 17:04:44 CDT 2003
Personally, I loved version 5 (the last non-MS version), but haven't been quite so thrilled with 2000 and 2002. For one thing, they took the forward engineering out of the Professional version in 2000 and moved it to Enterprise, although Enterprise was released later and then they wanted a full upgrade price *again* to move from Professional to Enterprise. At that point, I didn't bother. I still like it for design, although I've used other tools as well, but without the forward engineering, you might as well use another less expensive tool. Enterprise is just too expensive for what the product does for an Access developer, IMHO. However, I think it forces you to really think about your design in ways that rapid development in Access doesn't, and for that, I like Visio or DeZign. Charlotte Foust -----Original Message----- From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] Sent: Friday, May 09, 2003 1:03 PM To: accessd at databaseadvisors.com 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