Open another database from the one you have open

[blake7]

Hi all,
I have a requirement to open another database from within the current one I
have open, I am trying to do this with a button on a form, I have the
following code below but it does not work, the egg timer shows but nothing
happen, can anyone help. Thanks


Private Sub Command60_Click()
Dim accapp As Access.Application

Set accapp = New Access.Application

accapp.OpenCurrentDatabase "c:\my documents\quality issues log.mdb"
accapp.Visible = True
End Sub

 

[Daniel Pineault]

It depends on your needs, but if all you are trying to do is open it and make
it available to the user then use the FollowHyperlink method.

Application.FollowHyperlink "c:\my documents\quality issues log.mdb"
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[blake7]

Many Thanks Daniel, that works perfect
Regards
Tony