| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Hi Dennis,
To open a password protected Access database you've got to include the Password in the Properties collection of the ADO connection. Dim cnData As ADODB.Connection Set cnData = New ADODB.Connection With cnData .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data Source=c:\mydatabase.mdb" .Properties("Jet OLEDB  atabase Password") = "existingpassword".Mode = adModeShareExclusive .Open End With Regards, Gerard O'Donnell "Dennis" wrote: > Great code..I needed something like that. Next question, how do you open an > Access database that is password protected> > > "Gerard O'Donnell" wrote: > > > Hi Chris, > > > > This code will set a password to a previously unprotected Access database: > > > > Dim cnData As ADODB.Connection > > Set cnData = New ADODB.Connection > > With cnData > > .Provider = "Microsoft.Jet.OLEDB.4.0" > > .ConnectionString = "Data Source=c:\mydatabase.mdb" > > .Mode = adModeShareExclusive > > .Open > > End With > > > > cnData.Execute "ALTER DATABASE PASSWORD mynewpassword NULL" > > > > Regards > > > > Gerard O'Donnell > > > > "Chris Huddle" wrote: > > > > > Does anyone know how to programatically set a password for an Access > > > Database, preferably in ADO? Thanks! - Chris > > > > > > > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thanks. I wasn't sure of the syntax. This will help me a lot in what I'm
working on. "Gerard O'Donnell" wrote: > Hi Dennis, > > To open a password protected Access database you've got to include the > Password in the Properties collection of the ADO connection. > > Dim cnData As ADODB.Connection > Set cnData = New ADODB.Connection > > With cnData > .Provider = "Microsoft.Jet.OLEDB.4.0" > .ConnectionString = "Data Source=c:\mydatabase.mdb" > .Properties("Jet OLEDB atabase Password") = "existingpassword"> .Mode = adModeShareExclusive > .Open > End With > > Regards, > > Gerard O'Donnell > > "Dennis" wrote: > > > Great code..I needed something like that. Next question, how do you open an > > Access database that is password protected> > > > > "Gerard O'Donnell" wrote: > > > > > Hi Chris, > > > > > > This code will set a password to a previously unprotected Access database: > > > > > > Dim cnData As ADODB.Connection > > > Set cnData = New ADODB.Connection > > > With cnData > > > .Provider = "Microsoft.Jet.OLEDB.4.0" > > > .ConnectionString = "Data Source=c:\mydatabase.mdb" > > > .Mode = adModeShareExclusive > > > .Open > > > End With > > > > > > cnData.Execute "ALTER DATABASE PASSWORD mynewpassword NULL" > > > > > > Regards > > > > > > Gerard O'Donnell > > > > > > "Chris Huddle" wrote: > > > > > > > Does anyone know how to programatically set a password for an Access > > > > Database, preferably in ADO? Thanks! - Chris > > > > > > > > > > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can't open my Access files after conversion from Access 97 to Access 2003 | M Shafaat | Microsoft Access | 5 | 10th Apr 2010 09:04 PM |
| Saving Access 2007 database in Access 2003 format fails in Access | =?Utf-8?B?U3Bpcm8=?= | Microsoft Access External Data | 0 | 13th Aug 2006 08:37 AM |
| W2K3 Service w/ UNC Access, Local Disk Access, and DB Access | Rob | Microsoft C# .NET | 6 | 2nd Aug 2004 01:44 PM |
| Access "showing images on first page only of very wide Access report. Windows XP, Access XP | Jack | Microsoft Access Reports | 4 | 18th Nov 2003 03:01 PM |
| Re: Allowing users (w/o MS Access) to access an Access 2000 database | Wayne Morgan | Microsoft Access | 0 | 29th Sep 2003 11:46 PM |
