• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 124
  • Last Modified:

Opening an access application

Question:

Is it possible for me to open a particular form as well as a particular report in MS Access...programmitacally.
I am currently using visual c++ and some MFC classes.


0
eugene007
Asked:
eugene007
  • 3
1 Solution
 
jhanceCommented:
Yes, Access fully supports OLE/COM and that is the best way to do it from VC++.  You can also just start running Access from VC++ using ShellExecuteEx and pass it a VBScript file to do the work.
0
 
eugene007Author Commented:
hi jhance...i have tried this way but its still not working.
 
SHELLEXECUTEINFO ShExecInfo;
ShExecInfo.cbSize = sizeof(SHELLEXECUTEINFO);
ShExecInfo.fMask = NULL;
ShExecInfo.hwnd = NULL;
ShExecInfo.lpVerb = NULL;
ShExecInfo.lpFile = "C:\\My Documents";
ShExecInfo.lpParameters = NULL;
ShExecInfo.lpDirectory = NULL;
ShExecInfo.nShow = SW_MAXIMIZE;
ShExecInfo.hInstApp = NULL;

ShellExecuteEx(&ShExecInfo);


i am trying to open the application separately.


Regards

Eugene

0
 
jhanceCommented:
Check the SDK docs for the proper format of the SHELLEXECUTEINFO parameters but this certainly isn't going to do much:

ShExecInfo.lpFile = "C:\\My Documents";

0
 
syedhsCommented:
A quick look at the code makes me wonder..
why is it the lpFile points to My Documents.?
why not say you want to open an Access file (mdb).. change it to
"C:\\My Documents\\aaa.mdb"
0
 
jhanceCommented:
Check the SDK docs for the proper format of the SHELLEXECUTEINFO parameters but this certainly isn't going to do much:

ShExecInfo.lpFile = "C:\\My Documents";



0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now