Working from my Front End called “SRT Systems” what I’m attempting to do is open another Front End called AWS07_PRoberts.mdb” using the following :
Private Sub txtKeyZ_Click()
Dim app As New Access.Application
app.OpenCurrentDatabase "S:SRT AccessSystemsSRT ServerAWS07_PRoberts.mdb"
app.Visible = True
Set app = Nothing
And it works very nicely.
Two things that I would like to be able to do at this point are:
1. Have my “Click” button passworded, and
2. Close my Front End
I’d appreciate any help on this,