open access from access

[LJA520]

Hello,

I'm creating a database that will open other databases to run stuff. I need the database to open and be visible. IT works when I try to open an access database from my c:\ but I get errors when trying to open a file from my network drive.

Does anyone know how to open an access database on the network drive in access??

Any help is much appreciated!!

Thanks,
LJA

 

[PHV]

I get errors
Any chance you could post the whole error message(s), the code you tried that worked and the one that raises the error ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[LJA520]

Well I just realized that the string I was using included spaces, so I added quotes around it. It's working now, but here is the code,

Dim objShell As IWshShell
Dim lShellResults As Long


Set objShell = New IWshShell_Class

lShellResults = objShell.Run(Chr(34) & "c:\database list.mdb" & Chr(34), WshNormalFocus)

Set objShell = Nothing

Thanks, have a good day!