Solved

VB.Net reading Access ADP file?

Posted on 2007-11-19
4
259 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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Name space syntax error 12 56
Export import database 4 51
consuming an asmx web service in winforms application 3 37
Call Controller Action Method from ASPX 2 13
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

776 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