473,700 Members | 2,459 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem connecting to password protected Access file

Hi
I am trying to connect to a password protected access file from VB.NET.
I have no problem in connecting to Access, if I remove the password.

This is what I am doing:
In the server explorer, I choose "Add a connection"
Choose "Microsoft Jet 4.0 OLEDB Provider" in the provider tab
Selected the access file in the next tab
Left Username as Admin and typed the password.
Now when I try to test connection, I am getting this error message:
"Test connection failed becaues of an error in initializing provider. Cannot
start your application. The workgroup information file is missing or opened
exclusively by another user".

I am 100% sure, the password is correct, the file is not opened by any one.
I also created a workgroup information file and saved it under the same
folder that the access db is in.

If I remove the access password, I am able to connect. After creating the
data connection, I protected the access file with password. Now when I try to
refresh the data connection from Server Explorer, I am getting a popup form,
that asks for password and PROVIDER STRING. I am not sure what the Provider
stirng is, so I am always getting the above mentioned error message.

I would really appreciate if some one could help me out.

Thanks
Karthik
Nov 21 '05 #1
4 7566
On Thu, 27 Oct 2005 08:55:07 -0700, "kthiagar" <kt******@discu ssions.microsof t.com> wrote:

§ Hi
§ I am trying to connect to a password protected access file from VB.NET.
§ I have no problem in connecting to Access, if I remove the password.
§
§ This is what I am doing:
§ In the server explorer, I choose "Add a connection"
§ Choose "Microsoft Jet 4.0 OLEDB Provider" in the provider tab
§ Selected the access file in the next tab
§ Left Username as Admin and typed the password.
§ Now when I try to test connection, I am getting this error message:
§ "Test connection failed becaues of an error in initializing provider. Cannot
§ start your application. The workgroup information file is missing or opened
§ exclusively by another user".
§
§ I am 100% sure, the password is correct, the file is not opened by any one.
§ I also created a workgroup information file and saved it under the same
§ folder that the access db is in.
§
§ If I remove the access password, I am able to connect. After creating the
§ data connection, I protected the access file with password. Now when I try to
§ refresh the data connection from Server Explorer, I am getting a popup form,
§ that asks for password and PROVIDER STRING. I am not sure what the Provider
§ stirng is, so I am always getting the above mentioned error message.
§
§ I would really appreciate if some one could help me out.

If you are using user-level security (and not a database password) then you will probably need to
specify the path to the system.mdw (workgroup information file) in your connection string. If you
click on the All tab in the Data Link Properites dialog you can specify the path in the Jet
OLEDB:System database property.
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 21 '05 #2
Thanks Paul, but I am not using user level security. I thought if I use user
level security, the problem would be solved, but it doesnt look so.

So I removed the user level security.

Karthik

"Paul Clement" wrote:
On Thu, 27 Oct 2005 08:55:07 -0700, "kthiagar" <kt******@discu ssions.microsof t.com> wrote:

¤ Hi
¤ I am trying to connect to a password protected access file from VB.NET.
¤ I have no problem in connecting to Access, if I remove the password.
¤
¤ This is what I am doing:
¤ In the server explorer, I choose "Add a connection"
¤ Choose "Microsoft Jet 4.0 OLEDB Provider" in the provider tab
¤ Selected the access file in the next tab
¤ Left Username as Admin and typed the password.
¤ Now when I try to test connection, I am getting this error message:
¤ "Test connection failed becaues of an error in initializing provider. Cannot
¤ start your application. The workgroup information file is missing or opened
¤ exclusively by another user".
¤
¤ I am 100% sure, the password is correct, the file is not opened by any one.
¤ I also created a workgroup information file and saved it under the same
¤ folder that the access db is in.
¤
¤ If I remove the access password, I am able to connect. After creating the
¤ data connection, I protected the access file with password. Now when I try to
¤ refresh the data connection from Server Explorer, I am getting a popup form,
¤ that asks for password and PROVIDER STRING. I am not sure what the Provider
¤ stirng is, so I am always getting the above mentioned error message.
¤
¤ I would really appreciate if some one could help me out.

If you are using user-level security (and not a database password) then you will probably need to
specify the path to the system.mdw (workgroup information file) in your connection string. If you
click on the All tab in the Data Link Properites dialog you can specify the path in the Jet
OLEDB:System database property.
Paul
~~~~
Microsoft MVP (Visual Basic)

Nov 21 '05 #3
I have encountered the same problem and got help from ADO.net newsgroup,
below is the information I got:

"Try this string instead:
'Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=\somepat h\mydb.mdb;Jet
OLEDB:Database Password=MyDbPa ssword;'.""

And it solved my problem,

Peter
Nov 21 '05 #4
On Thu, 27 Oct 2005 13:35:01 -0700, "kthiagar" <kt******@discu ssions.microsof t.com> wrote:

§ Thanks Paul, but I am not using user level security. I thought if I use user
§ level security, the problem would be solved, but it doesnt look so.
§
§ So I removed the user level security.
§

OK, so then if you're using a database password then it should be specified in the Jet
OLEDB:Database Password in the list on the All tab.

If you're not using any security then either Admin with a blank password, or no user ID and password
at all (on the Connection tab) should work.
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
10779
by: Ian | last post by:
I'm hoping someome more knowledgeable than I can help me with a problem I'm having. I have been writing a system using PHP and MySQL and had it running for testing purposes on my own pc which is running Abyss web server software. Access to some of the website functionality is protected using the following kind of call: <?php if (!isset($_SERVER)) {
2
1770
by: news | last post by:
We currently have our mySQL server on the same box as the Apache server. For security and load balancing, we're going to be moving the mySQL server to another box. We're already using a single included connection file in all of our PHP pages that has the server, username, password line that connects to the database. Aside from changing "localhost" to the IP/port number of the new server, what else should be done, especially in the...
2
5280
by: Marc Stiegele | last post by:
Hello, I have a problem with the IBM DB2 UDB XML Extender. I`m working on a iSeries 400 server (AS/400, V5R1) with a integrated DB2 (my client is NT 4.0 Service Pack 1 with JDK1.1.8). I want to create XML files out of the DB2 data using the XML collections method and SQL mapping. I successfully enabled my database, put the collection.dtd into DTD_REF, created a DAD file and enabled the collection (xcolltest01) using the OS/400 command...
3
6311
by: Chris | last post by:
I have a frontend that has some tables which are linked to a backend. Now I want to make the backend password protected and when I try to run it password protected I can't open it. In the first form that opens in the front end, I added the following to the form_open event: Dim cnn As ADODB.connection Set cnn = New ADODB.connection cnn.Provider = "Microsoft.Jet.OLEDB.4.0" cnn.Properties("Data Source") = "C:\backend.mdb"
3
4866
by: Kris van der Mast | last post by:
Hi, I've created a little site for my sports club. In the root folder there are pages that are viewable by every anonymous user but at a certain subfolder my administration pages should be protected by forms authentication. When I create forms authentication at root level it works but when I move my code up to the subfolder I get this error: Server Error in '/TestProjects/FormsAuthenticationTestingArea' Application.
4
1985
by: Arsalan Ahmad | last post by:
Hi all, I have a MS Access database (say abc.mdb). I have set the database password and admin password to "abcdefg" (say). The problem is that when I create a simple application (a form-based application or asp.net application) and try to connect to the database using ado.net i get following error: ERROR : Test connection failed because of an error in initializing provider.Cannot start your application.
5
2126
by: Sebastian | last post by:
I'm using the following code to connect to an access 2000 database. (with reference to adodb) Public DBvar As New ADODB.Connection() DBvar.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Data.mdb", "userID", "Pass") Previously I was connecting with just DBvar.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data
1
1896
by: Chris Love | last post by:
I have already asked this, but no one seems to know the answer. Here is the timeline. I wanted to use the membership/roles functionality in a site. I got all sorts of errors trying to get this setup on the site through the admin interface. So I yanked it out of the application since it did not work. Now everytime I load the site after changing the application I get this error message. If I simply refresh the page, everything works...
0
1501
by: Rafa | last post by:
Hello, First, sorry because I am spanish and my english are not good. My problem is that i am trying to work with profiles in visual studio 2005, but i have an error. the error is that: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that
0
8726
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
9075
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8973
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8925
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6561
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Duprť who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5903
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4404
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4657
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3089
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.