p2p.wrox.com: Archives - access archive

access thread: Opening a Secured Access database using VB and ADO

Message #1 by "Mark E. Watkins" <wattem@h...> on Thu, 9 Aug 2001 23:32:51 -0500

Hi,



Can anyone help me figure out how to open a secured Access database, 

using ADO and Visual Basic.  The following shows the ConnectionString 

and what I set it to.  My password is correct...so that is not it.



        .ConnectionString 

"Provider=Microsoft.Jet.OLEDB.4.0;Password=MyPassword;User 

ID=Admin;" & _

            "Data Source=" & GetDBPath





And I tried the following as well...





        .ConnectionString 

"Provider=Microsoft.Jet.OLEDB.4.0;Password=MyPassword;User 

ID=Admin;" & _

            "Data Source=" & GetDBPath & ";" & _

            "Persist Security Info=True;" & _

            "Jet OLEDB:System database=" & GetMDWPath



The GetDBPath and GetMDWPath are functions to retrieve the paths from 

the registry.



- Thanks

Mark

Message #2 by "Mark E. Watkins" <wattem@h...> on Fri, 10 Aug 2001 01:41:16 -0500

The ConnectionStrings Password and UserID are as follows...ooops...



        .ConnectionString

"Provider=crosoft.Jet.OLEDB.4.0;Password=MyPassword;User

            ID=Ad�min;" & _

            "Data Source=& GetDBPath



Sorry...



----- Original Message -----

From: "Mark E. Watkins" <wattem@h...>

To: "Access" <access@p...>

Sent: Thursday, August 09, 2001 11:32 PM

Subject: [access] Opening a Secured Access database using VB and ADO





Hi,



Can anyone help me figure out how to open a secured Access database,

using ADO and Visual Basic.  The following shows the ConnectionString

and what I set it to.  My password is correct...so that is not it.



        .ConnectionString

"Provider=crosoft.Jet.OLEDB.4.0;Password=Password;User

ID�min;" & _

            "Data Source=& GetDBPath





And I tried the following as well...





        .ConnectionString

"Provider=crosoft.Jet.OLEDB.4.0;Password=Password;User

ID�min;" & _

            "Data Source=& GetDBPath & ";" & _

            "Persist Security Info=ue;" & _

            "Jet OLEDB:System database=& GetMDWPath



The GetDBPath and GetMDWPath are functions to retrieve the paths from

the registry.



- Thanks

Mark

Message #3 by "Pardee, Roy E" <roy.e.pardee@l...> on Mon, 13 Aug 2001 11:21:53 -0700

You're on the right track.  See:



http://support.microsoft.com/support/kb/articles/Q191/7/54.ASP



for sample connect strings.



Cheers,



-Roy



-----Original Message-----

From: Mark E. Watkins [mailto:wattem@h...]

Sent: Thursday, August 09, 2001 9:33 PM

To: Access

Subject: [access] Opening a Secured Access database using VB and ADO





Hi,



Can anyone help me figure out how to open a secured Access database,

using ADO and Visual Basic.  The following shows the ConnectionString

and what I set it to.  My password is correct...so that is not it.



        .ConnectionString

"Provider=3DMicrosoft.Jet.OLEDB.4.0;Password=3DMyPassword;User

ID=ADmin;" & _

            "Data Source=3D" & GetDBPath





And I tried the following as well...





        .ConnectionString

"Provider=3DMicrosoft.Jet.OLEDB.4.0;Password=3DMyPassword;User

ID=ADmin;" & _

            "Data Source=3D" & GetDBPath & ";" & _

            "Persist Security Info=3DTrue;" & _

            "Jet OLEDB:System database=3D" & GetMDWPath



The GetDBPath and GetMDWPath are functions to retrieve the paths from

the registry.



- Thanks

Mark

Return to Index

P2P Archives