?
Solved

VB.Net reading Access ADP file?

Posted on 2007-11-19
4
Medium Priority
?
280 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 1000 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

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …
Watch the video to know the process of migration of Exchange or Office 365 mailboxes in absence of MS Outlook. It is an eminent tool which can easily migrate Public, Archive user mailboxes from one another Exchange server and Office 365. Kernel Migr…

568 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