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

Posted on 2010-11-29
Medium Priority
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)

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

Expert Comment

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

Author Comment

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.
LVL 18

Accepted Solution

lludden earned 1000 total points
ID: 34233927
The tables are linked from whatever the data source is for the project.
LVL 86
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.

Author Closing Comment

ID: 34530260
Sorry about the delay in excepting this.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
An ASP.NET Web Form User Control is not newly introduced in ASP.NET. In fact, it was an old technology yet still playing a role to generate web content, especially when we want to use it to have a better and easy way to control part of the web conte…
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

627 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