Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

VB.Net reading Access ADP file?

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
sirbounty
Asked:
sirbounty
  • 2
  • 2
1 Solution
 
grayeCommented:
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
 
sirbountyAuthor Commented:
Oh, so there's a SQL backend to this somewhere?
0
 
grayeCommented:
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
 
sirbountyAuthor Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now