[AccessD] From a reader

William Hindman wdhindman at dejpolsystems.com
Wed Mar 11 12:21:37 CDT 2009


...dl the Visio 2007 60 day trial ...imnsho, one of the few things in the 
Office 2007 line worth the upgrade over 2003.
William

--------------------------------------------------
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
Sent: Wednesday, March 11, 2009 11:32 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] From a reader

> Thanks.  I'll give it a try.
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Wednesday, March 11, 2009 8:20 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] From a reader
>
> Depends on the version you have, Rocky.  There is a learning curve, but I
> started with Visio 1, long before MS bought it, so I don't really know how
> steep it would be starting with a late version.  It has the capability of
> importing a database schema from an mdb and it allows you to specify items
> to include/exclude.  It only works with an unsecured database and I don't
> know if it handles anything but an mdb these days because I'm not actively
> using it.  Once you have imported the schema, you can create pages and put
> tables and their relationships on whichever page you want in order to 
> group
> them.  You can save the resulting diagram to html, among other formats, so
> it can be viewed in a browser without Visio involved at all after that.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> Beach Access Software
> Sent: Wednesday, March 11, 2009 7:58 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] From a reader
>
> Charlotte:
>
> I've never used Visio because I've not had a need for it - looked at it 
> once
> and seemed to have a bit of a learning curve - but I have a copy.
> And have occasionally wished I could print a nicer relationships diagram.
> Is it easy to get Visio to do this?
>
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
> www.bchacc.com
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Tuesday, March 10, 2009 1:59 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] From a reader
>
> Sounds like they wind up tripping over the maximum number of objects on an
> Access report, Susan.  They must have gone hog wild on relationships!
> Making the relationships smaller would mean removing some of the tables 
> (not
> the relationships) from the layout and printing it a piece at a time.  If
> you don't remove the relationships, they remain, they just aren't visible 
> in
> the layout at a given time.  You can always use show all to see all the
> tables and start removing them again to get down to another layout.
> Unfortunately, there's no way to save more than one layout, but you could
> capture the preview to a pdf file for later, I guess.
>
> If they want one huge diagram, they're going to have to look to a 3rd 
> party
> tool that can reverse engineer the relationships and schema from the
> database file.  DeZign for Databases is a tool I used to use, among 
> others.
> Visio was my favorite for years, but MS priced the useful versions out of
> the market for me.  DeZign is reasonably priced but doesn't produce 
> layouts
> that look as pretty.
>
> Charlotte Foust
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Tuesday, March 10, 2009 1:51 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] From a reader
>
> The relationships have grown large enough that Access won't print them.
> I've never run into this, but would be interested in a solution if you 
> know
> of one. I think the error is a bit peculiar as I don't understand how 
> making
> the layout smaller would help -- not really sure what that even means!
>
> Thanks!
> Susan H.
>
> "We've created a significant database using Microsoft Office Access (works
> in both 2003 and 2007).  Over the years the relationships have become more
> complex. We would like to be able to print a large format report (11" x 
> 17")
> or to segment the report into pages we can manually tape together.
> Currently when we try we get:
> ------------------------------------------------
> Print Relationships Error Box
> i The Relationships window layout is too large to fit in a Microsoft 
> Office
> Access report.  Some of the tables and/or relationship lines will not show
> up in your report.  To print all relationships, make the layout smaller 
> and
> run the wizard again.
> -------------------------------------------------
> Do you know of a method to allow us to overcome this limit or perhaps a 
> 3rd
> party tool that can help us?"
>
>
> --
> 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