[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2010-11-29
5
Medium Priority
?
919 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 1000 total points
ID: 34233927
The tables are linked from whatever the data source is for the project.
0
 
LVL 85
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

650 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