Ben & Matt, All you need is to add quotes to your string, so: stAppName = "C:\Program Files\MapInfo\Professional\Mapinfow.exe " + """P:\Shared Information\LSDDatabase\LSD\LSD.MBX"""
Call Shell(stAppName, 1) This'll take care of the space that is causing the problem. Michael Hanna Industrial Engineering United Parcel Service Canada Ltd. (905) 660-8688 -----Original Message----- From: Ben Crane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 10:30 AM To: [EMAIL PROTECTED] Subject: MI-L Odd Question: Access, VBA and MI Hi list, This is not a question I really want to ask, but it's been bothering me. stAppName = "C:\Program Files\MapInfo\Professional\Mapinfow.exe " + "P:\Shared Information\LSDDatabase\LSD\LSD.MBX" Call Shell(stAppName, 1) My access program says it can't find file "Shared"! I know it's having a problem with the space between Shared and Information, and we've already created a small batch file, and tried a small MB to run the application; but it's cumbersome and ugly...anyone know how I can get this problem to go away... It's not a true MB question and for that I'm sorry... Thanx Ben & Matt __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
