I need to run access from within VB, a button clicks then access runs. Problem is i dont know what the command is, I tried "Microsoft Access" but that didnt work, its supposed to be the same command that you use from the command prompt right? so i tried that in the command prompt i get a folder opening name Microsft located at "C:\WINDOWS\system32\Microsoft". Am i using the wrong command, also this is the code i have basically
"AppActivate Shell("Microsoft Access" & App.Path & "\comp dep inventory(access97 format).mdb", vbNormalFocus)"
If anyone knows can you tell me the correct command.
P.S I am running Microsoft Office 2003, does that make a difference?