Can not see anymore table relationship

[Frank Situmorang]

Hello,

I just finished my church membership database. For other churches I renameed
it and coverted it into Access 2002 form ver.2000.

I do not know when I see the table , I can not see anymore the line
relationship, but wonder the program is still runnung well, all the reports
and form is till running well.

Can anyone help me? Moreover what should we do first. These are what I want
to do with the database
1. Convert it
2. Split it
3. make MDE.

Thanks in advance

 

[banem2]

Hello,

I just finished my church membership database. For other churches I renameed
it and coverted it into Access 2002 form ver.2000.

I do not know when I see the table , I can not see anymore the line
relationship, but wonder the program is still runnung well, all the reports
and form is till running well.

Can anyone help me? Moreover what should we do first. These are what I want
to do with the database
1. Convert it
2. Split it
3. make MDE.

Thanks in advance

Maybe you have scrolled down or right too much so you don't see tables
and relations?

1. Convert to what?
2-3 OK

Regards,
Branislav Mihaljev, Microsoft Access MVP

 

[Frank Situmorang]

Banem:

When I open my database I go to tool on the menu then to relationship,
Nomrally we can see the tables and lines of table relationship. But now lines
disappreared while the tables are still there and everything is running well.
But I want to see the line of relatioship there.

I converted it from Access 2000 to Access 2002.

Thanks for your help

 

[John W. Vinson]

Banem:

When I open my database I go to tool on the menu then to relationship,
Nomrally we can see the tables and lines of table relationship. But now lines
disappreared while the tables are still there and everything is running well.
But I want to see the line of relatioship there.

I converted it from Access 2000 to Access 2002.

Thanks for your help

Have you selected the "View All Relationships" button or menu option?

 

[Frank Situmorang]

John,

I do not understand what you said " View All Relationship". What I do is go
to access menu at the topp " Tools---> Relationship, then we can see all
tables with teir relationship lines. But now I see the tables but no more
lines.

It seems the reason because I converted it from Access 2000 to Access 2002,
because I see my backup before converstion I still see the lines of
relationship as usual.

Could you please help me how can I solve the problem, because I want to
distirubute my church membership database to many churches of my denomination.

Or is it because I renamed it?. What is the best way to replicate it or
rename it.

Thanks for your help.

 

[John W. Vinson]

John,

I do not understand what you said " View All Relationship". What I do is go
to access menu at the topp " Tools---> Relationship, then we can see all
tables with teir relationship lines. But now I see the tables but no more
lines.

There is an icon in the relationships window toolbar with nine table icons on
it; if you hover the mouse over it it should say something like "show all
relations". Or you can use the Relationships menu option and choose Show All.

It seems the reason because I converted it from Access 2000 to Access 2002,
because I see my backup before converstion I still see the lines of
relationship as usual.

The conversion itself *shouldn't* damage relationships but it's possible that
it did.

Could you please help me how can I solve the problem, because I want to
distirubute my church membership database to many churches of my denomination.

I'd love to see a copy. It sounds like you've put a lot more into it than the
little one I've been giving away!

Or is it because I renamed it?. What is the best way to replicate it or
rename it.

Thanks for your help.

Replication is VERY complex and not appropriate in this case. Just renaming a
..mdb file should not affect anything (unless you have some code explicitly
referencing the database name).

Is this application split into a frontend and backend? For a multiuser
database it certainly should be; it's a good idea even for a single user
database if you will be maintaining the forms, reports etc. for a
client/customer. If it is split, then the relationships actually should exist
only in the backend, the file containing the tables. Do you have any relinking
code?

You can check to see if there ARE relationships defined (even with the
relationships window failing to display them) with this VBA code. Copy and
paste it into a new Module; save the module as basRelationships; select
Debug... Compile from the VBA editor menu. Then in the Immediate window type

Call ShowAllRelations


====== code starts here =======

Sub ShowAllRelations()
Dim db As DAO.Database
Dim rel As Relation
Dim fld As Field
Set db = CurrentDb
For Each rel In db.Relations
Debug.Print "Relation "; rel.Name, rel.Table, rel.ForeignTable
For Each fld In rel.Fields
Debug.Print fld.Name; " linked to "; fld.ForeignName
Next fld
Next rel
End Sub


==== code ends here =======

 

[Frank Situmorang]

Thanks very much John, your explantion is very comprehensive, it's very
helpful to me. I would send you my database but it is big enough, it is more
than 6 MB, if I can compress it I can send it to your email.

Thanks a lot

 

[John W. Vinson]

Thanks very much John, your explantion is very comprehensive, it's very
helpful to me. I would send you my database but it is big enough, it is more
than 6 MB, if I can compress it I can send it to your email.

Thanks a lot

I'd appreciate it, Frank! You can rightclick the file in Windows Explorer and
choose Send To.... Compressed (zipped) Folder, or if you have WinZIP or PKZip
just use that. 6Mb is very reasonable (I presume you have used Compact and
Repair). My email address is jvinson <at> wysard of info <dot> com - just edit
out the blanks and fix the punctuation.

 

[Frank Situmorang]

John I have sent it to decompressed file, but it is still big 3.6 MB which is
heavy to send it thru our local mail. anyway I already just created again the
relationship link it is ok now. Actually, although I can not see the
relationship lines of the table, it works OK. I am only curious, why that
happened. I suspect it is because I converted it to ver 2002 because I see
also the other one that I converted, the same probelm happend.

Thank you John for all your help.