Solved

VB.Net reading Access ADP file?

Posted on 2007-11-19
4
257 Views
Last Modified: 2013-11-26
I used to have a project that read data from an Access MDB, but that's since been converted to an ADP file
I'm using .Net 2005 and would like some tips on how to now pull in the data that's in the ADP file...
0
Comment
Question by:sirbounty
  • 2
  • 2
4 Comments
 
LVL 41

Expert Comment

by:graye
ID: 20312909
I've tried that once...  but there is no provider for the ADP file.  (the OLEDB provider for the MDB file won't cut it)

So, you'd have to either a) create an MDB file with linked tables... or b) use the "native" SQL database directly

I ended up justed "going to the source" (the SQL database)... it was more elegant, quicker, and "normal"
0
 
LVL 67

Author Comment

by:sirbounty
ID: 20314002
Oh, so there's a SQL backend to this somewhere?
0
 
LVL 41

Accepted Solution

by:
graye earned 250 total points
ID: 20316680
Yep, that's how an ADP file works... it's just an Access "front end" to a SQL Server "back end".

When you open the ADP file, you'll get a new option on the File Menu called "server" (er, well... at least on Access 2007).   That menu item will show where the *real* database is
0
 
LVL 67

Author Comment

by:sirbounty
ID: 20321700
Good call - it was "Connection" in O2k3, but it also uses sql credentials of which now I have to pursue...
Thanx tho - good info! :^)
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now