VB to Access - Password Protected DB.
I am trying to connect to a Access 2000 DB from Visual Basic 6.0. Is there a way that I can pass in a password for the end user that would not have to type it in?
This is how I am accessing it:
Private appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.Visible = False
appAccess.OpenCurrentDatabase "C:\DB\Apartment.mdb", True
With appAccess.DoCmd
.OpenReport "Property Information", acViewPreview
.Maximize
End With
appAccess.Visible = True
John-
I am trying to connect to a Access 2000 DB from Visual Basic 6.0. Is there a way that I can pass in a password for the end user that would not have to type it in?
This is how I am accessing it:
Private appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.Visible = False
appAccess.OpenCurrentDatabase "C:\DB\Apartment.mdb", True
With appAccess.DoCmd
.OpenReport "Property Information", acViewPreview
.Maximize
End With
appAccess.Visible = True
John-
Last edited:
