Open another database from the one you have open

  • Thread starter Thread starter blake7
  • Start date Start date
B

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
 
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.
 
Back
Top