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.
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 2Thank 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. |
 |
|
|
|
|