Can you have too many tables?

Jeanette

Registered User.
Local time
Today, 14:40
Joined
Dec 17, 2001
Messages
52
I have an access data with 15 tables. Because my program has projects that can have several different situations per project, I have to create several many to many tables. My question is can a database have too many tables? It appears that I have to create yet another table with a one to many relationship.
 
How many tables are too many?

I may have to create a new table this time around because I have discovered that contractors and borrowers can have many different names for companies but have the same address and telephone number. Right now I have a Borrower/Contractor table with a field for company name. I do not want to have to create a new field everytime there is a new or different company name. This has happened in the past where situations come up where I am forced to create a new one to many table because of unforeseen situations. Thanks for your reply to my last posting.
 

Users who are viewing this thread

Back
Top Bottom