Hi there,

You can use the FollowHyperlink method, it will work for almost any program.
An example would look like ...


Option Explicit
Sub testingAccess()
Dim strPath As String, strName As String

'Change as desired..
strPath = "C:\YourFullPathNameHere\"
strName = "test.mdb"

On Error GoTo ExitSpot
ActiveWorkbook.FollowHyperlink strPath & strName, NewWindow:=True
Exit Sub

ExitSpot:
MsgBox Err.Description
End Sub


HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"rtphilips" wrote
in message ...

Hi

I have a access database "test.mdf"

While running a macro I want to open this database

Please provide some solution

Thanks


--
rtphilips
------------------------------------------------------------------------
rtphilips's Profile:
http://www.excelforum.com/member.php...o&userid=28114
View this thread: http://www.excelforum.com/showthread...hreadid=476234