COM Objects

rcgomez11

Setup:
Windows 7 Professional x64
WAMP 2.1

Good day PHPBuilders,
I'm having hard time figuring out whats the right way to do to make my MS Access Reports be executed/viewed through php script.

shell_exec("\"C:\\Program Files (x86)\\Microsoft Office\\Office12\\msaccess.exe\" \"E:\\central\\projapps\\HSSE\\hsse.mdb\" /X \"HSSE TRAINING STATISTIC\"");

I'm using this single line of code, and I got two setups in my apache.
*WAMPapache service is set to manual start
First setup,
1) WAMP server is not running
2) httpd.exe is running as console application, just a black window(cmd prompt-like)
3) When I tried to run the above code, it will generate the report and viewed in MS Access window
4) but I can't viewed the whole website (localhost)...
Second setup,
1) WAMP server is running
2) httpd.exe is not running as consode application
3) The above code will not work, it doesn't show my report
4) local website will be viewed perfectly...

I want to use the reports that I have in MS Access and generate that using php script, and I need it badly, and I know you can help me with my problem. Thanks in advance and I hope I deliver myself clear. Thanks again.

Sincerely,
Romel Gomez

bradgrafelman

Couple of questions about the Apache Windows service:

Does the account it is configured to "Log on as" have permissions to both execute msaccess.exe and read hsse.mdb in your command line above?
If the service is configured to log on as the "Local System account", did you grant the permission (checkbox on Log On tab) to "Allow service to interact with desktop" ?

rcgomez11

Yeah, I think so. I made all the folders that contains the msaccess.exe, hsse.mdb and httpd.exe granted to full control and make the owner as administrator.
I also configure my wampapache service to log on as "Local System Account" and the "Allow service to interact with desktop" checked.

But still, I can't viewed my report in MS Access. "Interactive Services Detection" still pops-up and not MS Access report. I'm using port 80 in my apache, just so you know. Thanks for the reply.