Need Relationships

[Learn2010]

I have a FE-BE database that I created and have been adding to for about four years. Now management wants a copy of it so they can put it on the internet. SharePoint is out. I get the usual resentment when I mention Access.

I have over 1300 queries. The last six months I have been using some SQL statements in order to learn SQL. I never created relationships between any of the tables. I did it all within the queries. They will undoubtedly want to see the relationships. The last time they put one of my databases on the internet I explained that I didn’t need them in Access. They thought I was crazy.

My dilemma is this. Is there a programmable way to set up the relationships without going through the tables one at a time? Any help would be appreciated.

 

[CJ_London]

Relationships are usually between tables typically (but not always) between the primary key of table 1 and the family key of table 2. The major point of relationships is to enforce data integrity and provide a visual mapping of all the tables. If you concentrate on tables this should cut the numbers down a bit

I'm not aware of a utility that will do this but you could write a routine going through each of the querdefs, looking for table names that are joined to other tables and extracting the table and field names and the join type

 

[Learn2010]

That would take me more time than going through them manually. But, I can probably use this in the future.

Thanks.