ADP文件中的数据库连接信息在哪里？ [英] Where is the database connection information in an ADP file?

问题描述

用户为旧的Access数据库输入了一个票据，并形成他们每天使用的项目。他们说数据库在使用时无法找到。我没有使用MS Access设计数据库或接口，所以我不知道在哪里可以找到它正在访问的数据库。

我想尝试并定位数据库，看看是否1）它存在和2）没有损坏

主界面通过* .adp文件完成。

Ive在MS Access 2007中打开它。

解决方案

使用ADP时，SQL Server将用于所有数据存储。
$ b $在立即窗口中（去 Ctrl + g ），检查 ConnectionString 和 Provider 属性：

 ？ CurrentProject.Connection.ConnectionString 
？ CurrentProject.Connection.Provider 
  

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.

解决方案

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

这篇关于ADP文件中的数据库连接信息在哪里？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！