opening access from vb 6.0 - command line error

[john1951]

Hello
I have written a program in VB 6.0 and I want to be able to open my mdb file by clicking on a command button.

this is my code for opening access

retval = Shell("C:\Program Files\Microsoft Office\OFFICE12\MSACCESS " & filestring & " /nostartup, 1")

this is the string that is sent by the Shell statement
C:\Program Files\Microsoft Office\OFFICE12\MSACCESS c:\program files\jhl jobs\newjob\jobs.mdb /nostartup, 1

I get several error messages (in Hebrew) that indicate an error caused by the string I am passing. Finally Access opens, but doesn't open my database file

Thank you
John

[Rawb]

The problem is most likely with how Windows tokenizes command line input. In short, you need to put quotes around the strings for it to work properly:

retval = Shell("'C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE' '" & filestring & "' /nostartup, 1")

I'm not sure if this will work (you may need to use double quotes, which is frustrating and confusing to me ) instead.