Relationship in MS-Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a database (MDB) with the one -to-many relationship in most of
the table and having front-end developed in Visual basic, I am using this for
so long, but suddenly while working through the front-end suddenly the
relationship of the database are completely gone out and after that I cann't
able to see the relationship.

Please help me out in searching for the reason of automatic deletion of the
relationship and how can I prevent the same?

Thanks all
 
When you open the Relationships and find it empty right click anywhere and
select Show All. You will probably find they are there and intact.
HTH
Terry
 
Thanks for the response, In Relationship window I can see all the tables but
the links between all of them are not there i.e. you can able to add or enter
irrelevent data to the child table.

Please help....
CJ
 
Sorry CJ I do not know.
You are using a Front End/Back End arrangement. Are you connecting to
different Back Ends? I have not seen the Relationships disappear.
Do you check the links on Startup and if necessary refresh the links?
Are the Relationships set up in VB or in the back end?
Terry
 
Hi,
I am using VB as the front-end and MS-Access as the back-end database but
all relationships are setup using the Access only. As per my understanding
relationships are setup for data integrity and for normilization of the
database. If this is not their in the database that anybody can enter the
irrevent data into the table and can delete any record.

Thanks for your reply.

Are their viruses like those can remove the relationship???????????
 
You do not always have the option - sometimes you are using someone else's
database with your front end but you can always keep your part clean.
Sorry! But I can think of no reason for them to disappear. The only reason I
can think of is, as I mentioned, you are connecting to another/wrong back
end. I have not seen them disappear other that having to actually show them
again. Sorry! I cannot help
Terry
 
Relationships must be defined in the front-end (the one containing the
actual tables). If you define them correctly, they (a) will work, and
(b) will not disappear unless someone takes them back out, using the
Access UI, or by running code to do that.

HTH,
TC
 
Back
Top