RE: Problem with pwd-protected Access .mdb
From: Scot Rose [MSFT] (scotr_at_online.microsoft.com)
Date: 02/24/04
- Next message: Tsevy: "move last record "doesn't display the last record"
- Previous message: Paul Baker [MVP, Windows - SDK]: "Re: ado recordset.recordcount has value 0"
- In reply to: Developer: "Problem with pwd-protected Access .mdb"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 15:58:16 GMT
Is it a Database password or a User password?
If it is a Database Password then you need to add this to your connection string
Jet OLEDB:Database Password=yourpassword
If it is a User password you need to add
;Password=userpassword;User ID=Username;Jet OLEDB:System database=c:\system.mdw
where System MDW is the Access System workgroup file you created when you set up the passwords.
Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : scotr@online.microsoft.com <Remove word online. from address>
This posting is provided “AS IS”, with no warranties, and confers no rights.
Get Secure!
http://www.microsoft.com/security
http://www.microsoft.com/protect
--------------------
>From: "Developer" <wanderer@mapinfo.nope.com>
>Subject: Problem with pwd-protected Access .mdb
>Date: Tue, 24 Feb 2004 09:16:47 -0500
>Lines: 16
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <#sLfYDu#DHA.3184@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.data.ado
>NNTP-Posting-Host: 199.29.3.157
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.data.ado:66772
>X-Tomcat-NG: microsoft.public.data.ado
>
>Hello,
>
>I'm trying to open a password-proteced Access table using an OleDbConnection
>in ADO.Net.
>This connection string:
> Provider='Microsoft.JET.OLEDB.4.0';Data source =
>C:\temp\dbpwd.mdb;Password=pwd;
>produces this exception:
> System.Data.OleDb.OleDbException: Cannot start your application. The
>workgroup information file is missing or opened exclusively by another user.
>
>What else do I need to do?
>
>TIA.
>
>
>
- Next message: Tsevy: "move last record "doesn't display the last record"
- Previous message: Paul Baker [MVP, Windows - SDK]: "Re: ado recordset.recordcount has value 0"
- In reply to: Developer: "Problem with pwd-protected Access .mdb"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
