Problem with shell cmd

Hello,

I am trying to open an msaccess database from within another. I'm using the command

shell "c:\program files\microsoft office\office10\msaccess.exe /c:\path\filename.mdb"

THe problem is that not only does it open the database as I wish, but it also gives me two "Online Meeting" error messages:

1) The Online Meeting feature requires Microsoft NetMeeting 2.11 or later. You can either ... etc."
2) Unknown network error.

At first it was also opening NetMeeting, but with considerable difficulty I was able to finally remove it from my hard drive and registry.

Any ideas?

wileedingo
LVL 1
wileedingoAsked:
Who is Participating?
 
Mike TomlinsonConnect With a Mentor Middle School Assistant TeacherCommented:
You don't need the forward slash (/) before your mdb file.  If the mdb filename has spaces in it then use double quotes around as shown below:

Private Sub Command1_Click()
    Shell "c:\program files\microsoft office\office10\msaccess.exe c:\path\filename.mdb"
End Sub

<or>

Private Sub Command1_Click()
    Shell "c:\program files\microsoft office\office10\msaccess.exe ""C:\Documents and Settings\Michael\My Documents\db1.mdb"""
End Sub

0
 
ColosseoCommented:
Hi wileedingo

Have you tried just

shell "c:\path\filename.mdb"

Also to you get the errors when you just open the other db normally?

Scott
0
 
wileedingoAuthor Commented:
Idle Mind - your first suggestion worked. Gee, and I spent all that time scrubbing Netmeeting off my hard drive. Oh well...  Incidentally, I had tried your second suggestion earlier, but it didn't work; do you think that's because there are no spaces in the path?

Scott - thanks, I had tried your suggestion as well without luck.
0
 
wileedingoAuthor Commented:
Tricky with those double double-quotes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.