Access 97 Many-to-Many Relationships 1

[grylnsmn]

I am a summer intern working at a mrtgage company andthey've asked me to design a database in Access 97 to handle their disaster recovery information. I've designed the database, but I've run into a problem implementing it.

I have a table to list what servers we have and another table to list the Applications we are using. My problem is that I need to be able to list multiple servers for each application, and also re-use the servers for other applications as well. After a little research, I learned about Many-to-Many relationships and decided to try using one.

The only thing is that it's not working. I can form the Many-to-One relationship between the ServerName table and the junction table, but I am unable to build a reltionship between the Application table and the junction table. It keeps telling me that it cannot build the relationship.

How could I fix this? As I said, I'm only an intern, but I would like to fix the problem they've given me. (I would go to other people here at the company, but I was given the assignment because almost no one else is even semi-familiar with Access.)

 

[MichaelRed]

The short answer is you have not constructed or populated the junction table properly. From your statement, I think
you may need two seperate junction tables.

The long answer is to ask exactly what response you get from exactly what operation you are attempting to perform, and to request at least some sample portions of the various tables.

A suggestion is to review the help system and implement the examples shown / discussed there and see how your situation parallels and differs fro the example(s).




MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[Guest_imported]

I have a data base on Microsoft Access 97 that I wanted to save on to Microsoft Word 97. I logged off on Friday and on Monday it had a password on it. What happened?

 

[tlbroadbent]

Jacksonmcn,

Your question should have been asked in a new thread particularly as it is unrelated to this thread.

Opening an Access database in Word and saving it corrupts the database. See

http://www.hammerdata.com/Newsgrp/298.html

for more information. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[BNPMike]

Never ever use many-to-many relationships.

You create an intersection entity which breaks the relationship into to two one-to-manys.

Your relation (table) is (Server,Application). The key is both fields together.

You can join Server in Server to Server in ServerApplication then join Application in Application to Application in ServerApplication. You can then do a 3 table query Select Server, Application, etc which will show you all the apps by server. Or you can go the other way from Application and see all the servers each app is on.

I can't see how you can go wrong with this. To start with don't declare relationships. Create your joins in the QBE screen or better still write a bit of SQL. It's very simple.

mike.stephens@bnpparibas.com