Solved

ADO Connection string syntax needed for vb.net to access with ADP file extension

Posted on 2010-11-29
5
904 Views
Last Modified: 2013-11-26

The client is written in vb.net.
The database is Access 2007 with an adp extension. I am trying to connect from vb.net directly to the access database with a adp file extension.
when the user opens the access database directly, he/she is required to enter a Logon name and password.



My vb.net code connection string looks like this:

      msAccessConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & txtFileIn.Text & ";Persist Security Info=True; Jet OLEDBatabase  User Id=xxxxxx; Password=yyyyy;"

      Dim conec As New OleDbConnection(msAccessConnectionString)
      conec.Open()

Error: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
0
Comment
Question by:jseg
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:lludden
ID: 34233668
The ADP files are project files only, they do not contain tables or any data.
0
 

Author Comment

by:jseg
ID: 34233737
As I open the database I enter the User ID and password.  When I click OK, I hold shift key at the same time.  When I do this I can see tables, queries, forms and reports.
0
 
LVL 18

Accepted Solution

by:
lludden earned 250 total points
ID: 34233927
The tables are linked from whatever the data source is for the project.
0
 
LVL 84
ID: 34234319
If this is an ADP, then those tables are hosted on a SQL Server. You can examine the ADP project to determine where that server is located, and then connect directly to that server from your VB.NET application.
0
 

Author Closing Comment

by:jseg
ID: 34530260
Sorry about the delay in excepting this.
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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

911 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

21 Experts available now in Live!

Get 1:1 Help Now