Programmatically listing Relationships of ADP file

[Barb Reinhardt]

I'm fairly new to access and would like to get a listing of the relationships
in the ADP file. How would I go about doing that programmatically? I
haven't the first idea of where to start. I did find something that said to
loop through the relationships collection, but I can't seem to find it.
FWIW, I'm fairly fluent in Excel VBA.

Thanks,

Barb Reinhardt

 

[Tom van Stiphout]

On Tue, 23 Mar 2010 12:30:01 -0700, Barb Reinhardt

A good start would be to open a VBA window, click the Help button, and
look for Relationships. Also don't forget to set a reference to the
Microsoft DAO <version> object library (Tools > References).

-Tom.
Microsoft Access MVP

 

[David W. Fenton]

=?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?=

I'm fairly new to access and would like to get a listing of the
relationships in the ADP file. How would I go about doing that
programmatically? I haven't the first idea of where to start. I
did find something that said to loop through the relationships
collection, but I can't seem to find it.

An ADP file being a container for use in connecting to a SQL Server,
it surely has no relationships. The database you're connecting to
does, but the ADP file cannot have any. I don't think the DAO
relationships collection will give you anything in an ADP, as Jet is
not involved in an ADP. You'll need to get that information from the
SQL Server, seems to me.

But I don't use ADPs, so I could be wrong on all of this.

 

[Barb Reinhardt]

Thanks for your help. This is all starting to make a bit of sense. I'll
try to get this information another way.

Barb Reinhardt