Open access mdb file with password

[mpires]

Hi

all, I'm digging for two days one way to execute access like we double click the mdb icon, but what i really need is to do this using vb.net. Hi have try to open the mdb as process / cmd / shell... and i'm able to open the file but i can't set the pwd. The mdb file as pwd to get open and the only way i have found was open mdb as vb.net object, but this way i have a problem because access will depend from vb.net and if we close vb.net app then access will close as well. My code:


Dim oAccess As Access.Application

' Start a new instance of Access for Automation:
oAccess = New Access.ApplicationClass()

' Open a database in share mode:

oAccess.OpenCurrentDatabase(filepath:="c:\x1.mdb", _
Exclusive:=False, bstrPassword:="xpto")

'Show Access aplication
oAccess.Visible = True

I need to execute access because i have made a login that interact with domain AD, and do another things before users can open the files.

Any idea to accomplish this is welcome

Regards,

 

[PHV]

Have a look here:

http://office.microsoft.com/en-us/access/HP051883001033.aspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886