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


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.
jsegAsked:
Who is Participating?
 
lluddenConnect With a Mentor Commented:
The tables are linked from whatever the data source is for the project.
0
 
lluddenCommented:
The ADP files are project files only, they do not contain tables or any data.
0
 
jsegAuthor Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
jsegAuthor Commented:
Sorry about the delay in excepting this.
0
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.

All Courses

From novice to tech pro — start learning today.