Opening an mdb from code

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Alan B. Densky" <sales@xxxxxxxxxxxxxxx>
Date: Sun, 8 Jun 2008 20:04:06 -0400

I want to open an mdb from within another mdb by clicking a button. I guess
that I've got my quotes messed up though, because I can't get it to work:

Dim stAppName As String

' stAppName = "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE
C:\My Documents\Neuro-VISION\SelfGrowthScraper\settings.mdb"

stAppName = "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" & "
" & "C:\My Documents\Neuro-VISION\SelfGrowthScraper\settings.mdb"
Call Shell(stAppName, 1)

Can somebody please straignten me out?

Thanks in advance.

Alan

.

Follow-Ups:
- Re: Opening an mdb from code
  - From: Douglas J. Steele

Prev by Date: Re: What delimiter do I use in the split() function for textbox te
Next by Date: Re: Opening an mdb from code
Previous by thread: What delimiter do I use in the split() function for textbox text?
Next by thread: Re: Opening an mdb from code
Index(es):
- Date
- Thread