open access VBA shell command without Netmeeting

[Guest]

I want to open another instance of Access from VBA code in a running instance
of Acccess, and I can do that, but how do I prevent Netmeeting from
automatically running and asking the user for their Name, email address,
password etc. and Then running Netmeeting?

The Code I'm running:

stAppName = "C:\Program Files\Microsoft Office 2000\Office\MSACCESS.EXE
/C:\CCDataShopNoticeGeneration\AccessData\AutoInstall.mdb "
Call Shell(stAppName, 1)

Are there comand line switches that will prevent Netmeeting from running?
When I open this database manually Netmeeting does not execute. It only runs
from the VBA command above. I have to prevent it. I don't want Netmeeting to
run at all. It will prevent what I'm trying to do!

Thanks )

 

[Graham Mandeno]

Hi Tony

I have no idea why NetMeeting is running, but the problem with your command
line is that there are spaces in the filename but you have not enclosed it
in quotes. Try this:

stAppName = """C:\Program Files\Microsoft Office
2000\Office\MSACCESS.EXE"" " _
& """C:\CCDataShopNoticeGeneration\AccessData\AutoInstall.mdb"""

Note that two adjacent double-quotes in a VBA string is interpreted as an
embedded double-quote.