running mdb from command window

[Caitlin11]

Hello - Here's my problem:

I've created a mdb that i'm trying to run from a command window. When I type "vemacro.mdb" at the command prompt the mdb runs fine. But - after it runs I get a popup error window that says "cannot find the file "f:\ve\vemacro.mdb" (or one of its compenents)." But - it DID find it and ran it just fine.

I'm running ms access 2003 and windows 2000.

Can anyone tell me what is causing this to happen??

Thanks!
Caitlin

 

[RuralGuy]

Put "f:\ve" in your path. When you first dropped into the Command Line you were probably in the f:\ve directory and after running the app you were probably in another directory. Adding "f:\ve" to your path will allow the CLI to find your mdb regardless of where you are in the directory structure.