• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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