Confused about Print Relationships

[Guest]

After puttering with Access off and on, I'm trying to build a serious
database. I have my initial table structure build and it's fairly complex.
But I want to make a consistent print of the tables and relationships to
study and use for documentation.

In Access 2003 I have been using the Relationships tool and print
relationships - but I feel like I'm fighting with it. Because:

1) I go into relationships and move the tables around to be organized
nicely. I print what I see (more on that in a sec). It asks me if I want to
save the layout and I say 'yes'. When I come back later and to into
relationships again the tables have moved all around again and duplicate
copies of some tables have appeared (Table1_1, etc). I delete them again and
the same thing happens again.

I know that this some times happens when you use lookup tables - I did and
first but I took them out...

what am I missing, why does this keep happening to me?

2) when I go into Print Relationships, my pages 1-3 are always blank and I
see table on p. 4 and on. No matter how I try to move things around, it still
comes out the same way.

Again, what am I missing?

I do feel like I'm being quite dense. Any ideas?

 

[Albert D.Kallal]

When I come back later and to into

relationships again the tables have moved all around again

Hum, I have not experienced the above. Are you running a split database by
any chance?
(the layout, and setup of tables and relationships has to occur in the back
mdb - you
thus have to open the back end...not the front end....

It is not clear if your database is split, but if it is, then you need to
open the back end for changes.

If you are new to the concept of splitting a database, then you can read the
following
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

If you not split, and your table layout still does not remain, I not sure
what your problem is....

2) when I go into Print Relationships, my pages 1-3 are always blank and I
see table on p. 4 and on. No matter how I try to move things around, it
still
comes out the same way.

When you select print relationships, and the "report" is finally displayed,
try going file->page setup. Change the margins to .5 all around.

Further, depending on your layout...perhaps landscape might also help.....
(just like a report that is too wide.....extra pages are printed...).

So, move the tables away from the margins...and lay them out going mostly
down....not across the page...

You can fit about 4 tables across, after that...you will have to print in
landscape mode.....

So, try narrowing out your table layout...or try printing in landscape
format....

And, the best solution?

Highlight one table in the relationships window...now hit the del key to
remove the table....keep hitting the del key over an over to delete all the
tables displayed (you are not harming anything...but just removing them from
the Relationships window).

Now, start over...place 3, or 4 tables...and check how they print......

Now...add 3 or 4 more tables....again again check how they print....

Do this, and you will see at what point your printout gets messed up.....

 

[Guest]

Hum, I have not experienced the above. Are you running a split database by
any chance?
(the layout, and setup of tables and relationships has to occur in the back
mdb - you
thus have to open the back end...not the front end....

It is not clear if your database is split, but if it is, then you need to
open the back end for changes.

If you are new to the concept of splitting a database, then you can read the
following
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

If you not split, and your table layout still does not remain, I not sure
what your problem is....


When you select print relationships, and the "report" is finally displayed,
try going file->page setup. Change the margins to .5 all around.

Further, depending on your layout...perhaps landscape might also help.....
(just like a report that is too wide.....extra pages are printed...).

So, move the tables away from the margins...and lay them out going mostly
down....not across the page...

You can fit about 4 tables across, after that...you will have to print in
landscape mode.....

So, try narrowing out your table layout...or try printing in landscape
format....

And, the best solution?

Highlight one table in the relationships window...now hit the del key to
remove the table....keep hitting the del key over an over to delete all the
tables displayed (you are not harming anything...but just removing them from
the Relationships window).

Now, start over...place 3, or 4 tables...and check how they print......

Now...add 3 or 4 more tables....again again check how they print....

Do this, and you will see at what point your printout gets messed up.....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.members.shaw.ca/AlbertKallal

Thanks for trying, Albert - but I'm afraid that's not it - the database is
not split.

 

[Albert D.Kallal]

Can you modify data...does the rest of the application work ok?

Perhaps try creating a blank new database, and import all of the old
stuff....does that work?

About the only think I can think of is the database is some how read
only...or is damaged....

Importing to a new database might very well fix this....