Solved

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

Posted on 2010-11-29
5
912 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

726 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