Solved

Problem with shell cmd

Posted on 2004-08-20
4
481 Views
Last Modified: 2009-07-29
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
0
Comment
Question by:wileedingo
  • 2
4 Comments
 
LVL 15

Expert Comment

by:Colosseo
ID: 11855790
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
 
LVL 85

Accepted Solution

by:
Mike Tomlinson earned 125 total points
ID: 11855843
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
 
LVL 1

Author Comment

by:wileedingo
ID: 11855929
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
 
LVL 1

Author Comment

by:wileedingo
ID: 11856780
Tricky with those double double-quotes.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question