Open second db

[dbalargin]

How do I open a second database from a procedure in a first?

 

[FoFa]

stAppName = "MSACCESS.EXE T:\CRIBWARE\misc_Stuff\Calibration_Control.mdb"
Call Shell(stAppName, 1)

 

[dbalargin]

I get an error that reads: The command line you used to start MS Access contains an option that MS Access doesn't recognize. Exit and restart MS Access using valid command-line options.
I am using Access 97 if that makes a difference.

 

[ghudson]

try...

Call Shell("C:\Program Files\Microsoft Office\Office\msaccess.exe C:\Databases\YourDB.mdb", vbMaximizedFocus)

 

[FoFa]

Since there are no options on that, not sure what to tell you. Have you tried entering it from a command (DOS) prompt to see what happens?

 

[dbalargin]

i am getting the same error as before. only the warning box is maximized

 

[FoFa]

COPY and PASTE (not retype) your code

 

[Mile-O]

Click Here

 

[dbalargin]

Mile-O-Phile...works like a charm. Thanks!