open another db

[lipin]

I am trying to use a command button to open another database, only I can't get it to work. I am guessing it is possible and I just can't get the syntax. I tried in OnClick event:
open G:/Adminsrv/Attend.mdb

why isn't this working?

 

[Newman]

Have not try it but I think it should be:
open Access.exe G:/Adminsrv/Attend.mdb
Hope that help!
Newman

 

[lipin]

Keep Getting : 'Expected As' Error at the G

 

[Newman]

wrong side
g:\Adminsrv\Attend.mdb

 

[John.Woody]

Try

Dim a

a = Shell("msaccess g:\Adminsrv\Attend.mdb" , vbMaximizedFocus)