databaseformsms-accessadp

Where is the database connection information in an ADP file?

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.

Solution

  • 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