Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 adp files saved to diskette (I can't retrieve them)

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-03-28 : 08:14:08
Guylaine writes "I had someone create a database on access 2000. I had this info placed on a diskette which I did download onto my Dell laptop. All info was retrieved without a problem. My Dell later crashed and I lost everything. I still however had the diskette. I am now using access 2003. I tried retrieving this info from the diskette onto the addesss 2003. It says they are adp files, it looks for a sql server and says access 2000 project disconnected.

I have never had a sql server. I can't retrieve my info (which I need desparately!). What do I do?

I have windows xp pro with all the latest updates including service pack 2

Thank you,
Guylaine"

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-03-28 : 08:51:11
an ADP file connects to SQL Server, so in the past even though you may not have realized it, all of the data your Access ADP file was using lived in a SQL Server database somewhere. (or MSDE) So, there's no data at all stored on your disk; the ADP file is just a collection of forms and reports and a connection to a SQL Server database.

When you try to open the ADP file, the error messages should tell you where it is trying to connect to. It may have been a local install of SQL Server on your previous computer. If so, then hopefully you have a backup of that database and can restore it. Otherwise, you are in trouble. If it connected to a network installion of SQL Server, then make sure you are authenticated onto the same network as before and have the same account/permissions as on your old computer.

The key is to understand exactly what an ADP file is, and how it works, so you can troubleshoot your issue.
Go to Top of Page
   

- Advertisement -