linking to an .mde file from .adp

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
 
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.
 
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)
 
Back
Top