How to make a code that could open/execute Microsoft Access 2007 ?

[johnchristian.pagnes]

Can someone please help me ? I made a button named "Open" for Visual Basic 6.0 , and i would like to execute/open Microsoft Access 2007, can someone please help me ...

[Learner010]

its not hard.
first off , just locate where is EXE for MS Access and then put the address in shell statement.this is what i've in vb.net , i'm not sure about this in vb6.But i think that it should work.

Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe")

[e.pol]

Learner010: yes.
johnchristian.pagnes: If you want to open report or anythings in access.exe, you need to make macro in access.exe before, and using (shell statement) command line to activate macro in access

[Hamza Saleem]

Regarding to Learner010 post :
Its better to use the statement like this

Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe",vbNormalFocus)

[NewCoder_31]

Shell("C:\Program Files\Microsoft Office\Office14\MSACCESS.exe",vbNormalFocus)