Opening an ACCESS db from the VBE in EXCEL

[Doctorjones_md]

What is the VBA code for opening an existing ACCESS database from the VBE ?
I can't find any specific reference to this when I google it.

Thanks in advance for any assistance.

 

[merjet]

http://www.erlandsendata.no/english/index.php?t=envbadac

Hth,
Merjet

 

[Jim Jackson]

ActiveWorkbook.FollowHyperlink Address:="C:\MyFolder\ _
MyDatabase.mdb", _
NewWindow:=True

 

[Doctorjones_md]

Many Thanks Jim -- your code worked BRILLANTLY!

Shane

 

[doctorjones_md]

I ended up using this code -- can't find the exact thread (or recall who
offered it), but it works GREAT!

ActiveWorkbook.FollowHyperlink Address:="\\Fileserver\Products.mdb", _
NewWindow:=True

Shane
==================================