linking to an .mde file from .adp

[Guest]

There is an .mde file on the network I'd like to see the relationships. I
linked to it using a regular .mdb file. I could only see the tables. I
tried linking using an .adp file. I installed the MDSE. I tried linking via
T-SQL and in the test connection I got the error:

"test connection failed because of an error in initializing provider.
cannot start your application."
It may have been looking for a connection string?

I tried linking via a linked SQL Server and and DNS. I get to the .mde file
in the network and I get the error message "the data connection wizard cannot
obtain a list of dbs from the data source".

Any suggestions?

tia,

 

[Guest]

You will not be able to retrieve that information from and mde. It is not
usual that an mde would have data internally. An mde should be a "front end"
application that links to an mdb that contains the tables. The relationships
will be in the database file that actually contains the data.

 

[Guest]

Also, note that unless you have specifically enabled that feature,
SQL Server will not be able to connect to an Access database
at all.(That feature was disabled for security reasons).

(david)