Where is the database connection information in an

Question

A user entered a ticket for an OLD Access database and form project that they use daily. They are saying that the database cannot be found when they use it. I haven't used MS Access to design a database or interface since college so I have no idea where to find the database it's trying access.

I want to try and locate the DB to see if 1) it exists and 2) is not corrupt

The main interface is done through a *.adp file. Where is the connection string information stored in the file?

Ive opened it in MS Access 2007.

Answer 1

With an ADP, SQL Server is used for all data storage.

In the Immediate window (go there with Ctrl+g), inspect the ConnectionString and Provider properties:

? CurrentProject.Connection.ConnectionString
? CurrentProject.Connection.Provider